Support #1746
open
reconciling household income between the main survey & covid-19 survey
100%
Description
Hi there,
Can I please get some advice on how to accurately compare household income in the main survey vs. the covid-19 survey?
As I understand, household income is collected differently in the main survey vs. the covid-19 survey. As household income is reported based on different periods in the covid-19 survey, I've first accounted for these periods to obtain a monthly value as follows:
gen covid_hhincome = .
replace covid_hhincome = hhincome_amount if hhincome_period 3
replace covid_hhincome = hhincome_amount*4 if hhincome_period 1
replace covid_hhincome = hhincome_amount*2 if hhincome_period 2
replace covid_hhincome = hhincome_amount/12 if hhincome_period 4
replace covid_hhincome = hhincome_amount*4 if hhincome_period 5
replace covid_hhincome = . if hhincome_amount -9 | hhincome_amount -8 | hhincome_amount -7 | hhincome_amount -2 | hhincome_amount -1
I then use fihhmnnet1_dv from the main survey combined with the above variable to form a total household income variable. Am I using the right income variable from the main survey?
Many thanks
Karen
Updated by Understanding Society User Support Team over 2 years ago
- Category set to Income
- Status changed from New to Feedback
- % Done changed from 0 to 90
- Private changed from Yes to No
Dear Karen,
Yes, fihhmnnet1_dv is the closest variable in the sense that this is net hh income from all sources. One important thing about the hhincome_amount variable is that it might happen that different household members provide different figures.
Best wishes,
Piotr,
UKHLS User Support Team
Updated by Understanding Society User Support Team about 1 year ago
- Status changed from Feedback to Resolved
- % Done changed from 90 to 100