Project

General

Profile

Support #1746

reconciling household income between the main survey & covid-19 survey

Added by Karen Arulsamy about 2 months ago. Updated about 2 months ago.

Status:
Feedback
Priority:
High
Assignee:
-
Category:
Income
Start date:
08/10/2022
% Done:

90%


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

#1

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

Also available in: Atom PDF