Support #1902

weights individual files waves 10 -11 wide format

Added by Annaelena Valentini 5 months ago. Updated 4 months ago.

Start date:
% Done:




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

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!


Updated by Olena Kaminska 5 months ago

Dear Annaelena,

Thank you for your question. Here is information on our weights that may be helpful to you:
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,


Updated by Understanding Society User Support Team 4 months ago

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

Also available in: Atom PDF