Project

General

Profile

Support #1655

Household income in Covid surveys

Added by Natalie Bennett 8 months ago. Updated 5 months ago.

Status:
Resolved
Priority:
Normal
Category:
COVID-19
Start date:
02/08/2022
% Done:

100%


Description

Hi

Could you advise me on the appropriate way to handle the income data provided in the covid-19 surveys? Am I right to think that the variable '_blhhearn_amount' would have to be multiplied by '_blhhearn_period' to standardise all of the amounts given to reflect the same time period? In addition, in the main survey there is a 'ieqmoecd' variable so that households can be compared. Is anything similar available in the covid survey data?

Many thanks

Natalie

#1

Updated by Understanding Society User Support Team 8 months ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 10
  • Private changed from Yes to No

Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.

We aim to respond to simple queries within 48 hours and more complex issues within 7 working days. While we will aim to keep to this response times due to the current coronavirus (COVID-19) related situation it may take us longer to respond.

Best wishes,
Understanding Society User Support Team

#2

Updated by Understanding Society User Support Team 8 months ago

  • Status changed from In Progress to Feedback
  • % Done changed from 10 to 80

Hi Natalie,

Yes, you need to multiply the hhincome_amount by a factor corresponding to the period provided in the hhincome_period, the factors for each of four periods (week, 2 weeks, month, year) will depend on your final outcome variable period (whether you want to get e.g. weekly income, or monthly income).
An equivalent to ieqmoecd is unavailable in the Covid-19 survey. However, you can try to create this variable on your own.
In wave 1 you can use the hhcomp variables set, you need to know the number of people in the household above and below age 14. The hhcomp composition categories go to age 15 not 14 but that would still produce a roughly comparable measure.
From wave 2 onwards you can use the personage* variables which give you the ages of everyone living with the respondent (in waves 2+, only for respondents completing survey in English, not for those completing in Welsh).

Best wishes,
Understanding Society User Support Team

#3

Updated by Understanding Society User Support Team 8 months ago

  • Assignee set to Understanding Society User Support Team
#4

Updated by Natalie Bennett 8 months ago

Hi

Thanks for this. However, I am unsure how to handle the top coding of these household composition variables when attempting to create this ieqmoecd variable. Should I take the category 3+ to be 3 as it is not possible to know if there are more than 3?

Many thanks

Natalie

#5

Updated by Understanding Society User Support Team 8 months ago

Hi Natalie,

Yes, I think it is the only solution.

Best wishes,
Understanding Society User Support Team

#6

Updated by Natalie Bennett 8 months ago

Ok great, thanks so much for your help.

Best wishes

Natalie

#7

Updated by Natalie Bennett 8 months ago

Apologies, I have one final question. I can't seem to find household income in any of the mainstage wave 9 data files included when I downloaded the Covid data. Can you tell me what the household income variable is called in the files with the 'jk_' prefix please?

Many thanks

Natalie

#8

Updated by Understanding Society User Support Team 8 months ago

Hi Natalie,

Household income variables were not included in the 2019 jk dataset. However, since wave 11 was released in Nov 2021, you can now link the household income from waves 10 & 11 hhresp data files to the jk_hhresp_cv file using j_hidp and k_hidp.

Best wishes,
Understanding Society User Support Team

#9

Updated by Natalie Bennett 7 months ago

Hi

That's great, thanks so much

Best wishes

Natalie

#10

Updated by Understanding Society User Support Team 5 months ago

  • Status changed from Feedback to Resolved
  • % Done changed from 80 to 100

Also available in: Atom PDF