Data With Negative Values

Data items that can have both negative and positive values, such as business income, total household income, etc, are provided as two variables:

• the variable for positive amounts; and
• the variable for negative amounts.

If the overall value is not missing and is positive, then the negative variable will be zero and the positive variable will hold the actual value. If the overall value is not missing and is negative, then the positive variable will be zero and the negative variable will hold the absolute value of the amount. For example, if we have a person with a business income loss of $20,000 in the last financial year, then the positive variable of business income will be zero and the negative variable will be $20,000.

Missing data information will be provided in both variables following the negative conventions described above.

Therefore, after handling the missing data, you can create your own variable by subtracting the negative variable from the positive variable. For example, you might set the missing values of business income to system missing and then create a new business income variable as follows:

    abifp-abifn