Support #553

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

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

Derived variables
Start date:
% Done:



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

Updated by Victoria Nolan about 8 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.


Updated by Gundi Knies about 8 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,


Updated by Victoria Nolan about 8 years ago

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

Also available in: Atom PDF