Support #1746
openreconciling 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 about 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 11 months ago
- Status changed from Feedback to Resolved
- % Done changed from 90 to 100