Project

General

Profile

Actions

Support #1481

open

Missing values vs negative income

Added by Leilah Plant-Tchenguiz almost 4 years ago. Updated about 3 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
-
Start date:
01/12/2021
% Done:

100%


Description

Hi, when looking at income variables (e.g. fimnlabgrs_dv) and I see negative integer values, how do I know whether these represent negative incomes or missing values?

Actions #1

Updated by Alita Nandi almost 4 years ago

  • Status changed from New to Feedback
  • Assignee set to Leilah Plant-Tchenguiz
  • % Done changed from 0 to 80
  • Private changed from Yes to No

The negative values -9 -8 -7 -2 -1 are set aside for missing values. Other negative values are actual negative values.

Hope this helps.
Understanding Society User Support

Actions #2

Updated by Leilah Plant-Tchenguiz almost 4 years ago

So suppose income were actually -7. Would you enter income as -7.00 to differentiate it from the missing values?

Actions #3

Updated by Alita Nandi almost 4 years ago

  • Assignee changed from Leilah Plant-Tchenguiz to Alita Nandi

I don't think we have encountered this issue yet as it is very unlikely to have income amount exactly -7 or -9. But if you are interested I can find out from the income team if in such cases they would change the income to something like -7.01

Actions #4

Updated by Alita Nandi almost 4 years ago

  • Status changed from Feedback to In Progress
  • Assignee changed from Alita Nandi to Leilah Plant-Tchenguiz
Actions #5

Updated by Alita Nandi almost 4 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Leilah Plant-Tchenguiz to Alita Nandi
Actions #6

Updated by Leilah Plant-Tchenguiz almost 4 years ago

That would be helpful, thank you.

Actions #7

Updated by Alita Nandi almost 4 years ago

  • Status changed from Feedback to Resolved
  • Assignee deleted (Alita Nandi)
  • % Done changed from 80 to 100
Actions #8

Updated by Piotr Marzec almost 4 years ago

  • Status changed from Resolved to In Progress
  • % Done changed from 100 to 80
Actions #9

Updated by Piotr Marzec almost 4 years ago

  • Assignee set to Alita Nandi
Actions #10

Updated by Understanding Society User Support Team over 3 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Alita Nandi to Leilah Plant-Tchenguiz
  • % Done changed from 80 to 90

The income team has confirmed that negative values -9 -8 -7 -2 -1 are reserved for genuine missing values.

Actions #11

Updated by Understanding Society User Support Team about 3 years ago

  • Status changed from Feedback to Resolved
  • Assignee deleted (Leilah Plant-Tchenguiz)
  • % Done changed from 90 to 100
Actions

Also available in: Atom PDF