Project

General

Profile

Actions

Support #1902

open

weights individual files waves 10 -11 wide format

Added by Aelen Valen over 1 year ago. Updated 11 months ago.

Status:
Resolved
Priority:
Urgent
Category:
Weights
Start date:
05/15/2023
% Done:

100%


Description

Hi,

I am trying to merge individual files across waves 10 and 11 into wide format to create a 2019 calendar year dataset.
I used this method from "Box 1: Example syntax for pooled analysis for cross-sectional estimation relating
to calendar year 2011, with weight re-scaling" in https://www.understandingsociety.ac.uk/sites/default/files/downloads/documentation/user-guides/mainstage/weighting_faqs.pdf

ge wts=0
replace wts=indpxui_xw if month>=13 & month<=24
ge ind=1
sum ind [aw=indpxui_xw] if month>=1 & month<=12
gen jwtdtot=r(sum_w)
sum ind [aw=indpxui_xw] if month>=1 & month<=12
gen kwtdtot=r(sum_w)
replace wts=indpxui_xw*(jwtdtot/kwtdtot) if month>=1 & month<=12

For the purpose of the research I am working on, I am using the equivalised household income and other variables referring to parental occupation, education and place of birth.

Since I am using it together with EUSILC 2019 for different EU countries, I was comparing the weights with the weights in EUSILC. While the sum of the weights in the latter equals on average the 80% of the real population in each country, the sum of weights of the dataset I created for UK 2019 (with the merge of wave 10 and 11) gives a number way lower than the census 2019 UK population.

Could you please help me understanding how those weights are constructed, which characteristics of the population they consider, whether they can comparable to ones in EUSILC and whether the procedure I followed to merge the two waves is correct.
Many thanks in advance for the support!

Actions #1

Updated by Olena Kaminska over 1 year ago

Dear Annaelena,

Thank you for your question. Here is information on our weights that may be helpful to you:
https://www.understandingsociety.ac.uk/sites/default/files/downloads/general/weighting_faqs.pdf
Note, the sum of the weights is an artificial number without any meaning, so you don't need to compare it across surveys.
If you want to estimate totals with UKHLS, provide the population total in your syntax, or estimate a proportion with our data and multiply it by the population total to get information in numbers of people.

Hope this helps,
Olena

Actions #2

Updated by Understanding Society User Support Team over 1 year ago

  • Status changed from New to Feedback
  • % Done changed from 0 to 80
  • Private changed from Yes to No
Actions #3

Updated by Understanding Society User Support Team 11 months ago

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

Also available in: Atom PDF