Support #2049

Linking BHPS and US Dataset for special license data (6931)

Added by Max Bradley 2 months ago. Updated about 1 month ago.

Data documentation
Start date:
% Done:



I am attempting to merge individual files from harmonised bhps and ukhls into long format. The datasets I am using are the special license datasets 6931. In the syntax provided in the documentation page, it uses the age_dv (i.e., derived variable). However, it seems that these dervide variables are not present in the BHPS indresp stata files. Could someone enlighted me as to whether I am missing something? Or perhaps, how to derive such variables myself?

Many thanks


Updated by Understanding Society User Support Team 2 months ago

  • Category set to Data documentation
  • Status changed from New to Feedback
  • Assignee changed from Max Bradley to Understanding Society User Support Team
  • % Done changed from 0 to 50
  • Private changed from Yes to No

Hello Max

The variable "age_dv" represents the age, in completed years, at the time of the interview. It is calculated using the date of birth stored in the sample administration database and the interview date (intdatd_if, intdatm_if, intdaty_if). If the date of birth is missing, it uses current and previous wave values of "dvage" to compute "doby_dv".

To create your own variable, you'll need access to SN6931 for the month of birth, which you already have, and to SN6676 (a controlled study) for the day of birth. For access levels and conditions, please refer to this link

Alternatively, you may consider using the BHPS variable "bw_age," which measures the age at the date of the interview. You could rename or create a new variable, i.e., "age_proxy" to match the name in both studies and continue using the syntax mentioned.

I hope this information is helpful.

Best wishes,
Roberto Cavazos
Understanding Society User Support Team


Updated by Understanding Society User Support Team about 1 month ago

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

Also available in: Atom PDF