Project

General

Profile

Support #1481

Missing values vs negative income

Added by Leilah Plant-Tchenguiz 8 months ago. Updated 7 months ago.

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

90%


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?

#1

Updated by Alita Nandi 8 months 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

#2

Updated by Leilah Plant-Tchenguiz 8 months ago

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

#3

Updated by Alita Nandi 8 months 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

#4

Updated by Alita Nandi 8 months ago

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

Updated by Alita Nandi 8 months ago

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

Updated by Leilah Plant-Tchenguiz 8 months ago

That would be helpful, thank you.

#7

Updated by Alita Nandi 8 months ago

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

Updated by Piotr Marzec 8 months ago

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

Updated by Piotr Marzec 8 months ago

  • Assignee set to Alita Nandi
#10

Updated by Understanding Society User Support Team 7 months 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.

Also available in: Atom PDF