Support #553

Measuring highest level of education in both the BHPS and US data

Added by vanessa gash about 4 years ago. Updated about 4 years ago.

Derived variables
Target version:
Start date:
Due date:
% Done:


Estimated time:


Dear Victoria,

I noted that you responded to a colleague’s question on this matter, but provided the solution via email, so I was unable to access your solution. (
I am using the BHPS and US as repeat cross-sections and am trying to control for differences between respondents in their educational levels. The BHPS has a variable which measures respondents highest educational level, the US appears not to (is this correct?). The only variable I can access using US is qfhigh, but this appears not to be asked of all respondents, at least not from 2010 onwards.

Also, am I correct in thinking that weights provided for US does not allow one to use the data as repeat cross sections (I am hoping for an equivalent of the BHPS variable: xrwght).

My best regards,


xwalk_hiqual_dv_4_bhps.pdf (16.8 KB) xwalk_hiqual_dv_4_bhps.pdf Crosswalk hiqual_dv for BHPS W1-18 Gundi Knies, 04/26/2016 07:14 PM
Look_up hiqual_dv.pdf (13.2 KB) Look_up hiqual_dv.pdf Variable mapping qfhigh, qualnew etc to _hiqual_dv Gundi Knies, 04/26/2016 07:14 PM


#1 Updated by Victoria Nolan about 4 years ago

  • Status changed from New to In Progress
  • Assignee set to Gundi Knies
  • % Done changed from 0 to 50
  • Private changed from Yes to No

Hi Vanessa,

Many thanks for your enquiry and for transferring it to the user support forum.

Please can I refer you to issue 551 ( which itself refers to the detailed response provided in 399 ( - we hope this helps.

My colleague Gundi can also add to this response with the code to derived hiqual_dv for the BHPS - I have therefore assigned this issue over to her to be updated further.

The cross-sectional weights in Understanding Society can be used for repeated cross-sections. Please refer to the user guide section on weights ( which provides an overview on which weights are provided and what they adjust for. Which weight to pick will depend on your research question.

Best wishes, Victoria.

#2 Updated by Gundi Knies about 4 years ago

Hi Vanessa,
further to Victoria's response, I am now uploading the code that we run to create a proxy for the Understanding Society variable _hiqual_dv in the BHPS. The education and highest qualification data have obviously been collected in a very different fashion so it will always be a good idea to test your results for any cross-study measurement issues. Please also read the associated variable notes for the qualifications-related derived variables in Understanding Society.

Best wishes,

#3 Updated by Victoria Nolan about 4 years ago

  • Status changed from In Progress to Closed
  • % Done changed from 90 to 100

Also available in: Atom PDF