Support #1691

Combining BHPS with US, as well as match children to parents across waves

Added by Viktoria Ancher-Jensen almost 2 years ago. Updated 3 months ago.

Data management
Start date:
% Done:



I am analyzing effects of divorce, and the outcomes I am investigating are the household income, education level, health and structure of own family - which is why I am using *_indresp, so that I have the adult responses from the "children"

For analysis, I would like to control for the household income, education and SES of the parents, which is why I need to be able to connect *_mnpid to the *_pidp - which I have been able to due with the syntax on your data management page.

To have the largest sample size possible, I would like to combine BHPS and US, and it is here I'm running into trouble.

I can use the syntax provided by you to combine the harmonized BHPS to US, but then I can't figure out how to match children with their parents. I have tried using the syntax to match children and parents in each wave individually, and then use the syntax to combine BHPS and US, but I keep getting error messages.

To sum up, is there a work around, to be able to combine both BHPS and US as well as matching children to their parents?


Updated by Understanding Society User Support Team almost 2 years ago

  • Status changed from New to Feedback
  • % Done changed from 0 to 50

The second option should work - first merge children with parents in each wave (BHPS & UKHLS) individually. It is not clear what the structure of the final dataset needs to be. For example, if you are trying to create a long format file of children with information of their co-resident parents attached to them, then after you have done the matching wave on wave (make sure that at the end of matching children and the parents, the pidp is the pidp of the children who you are analysing), you can append the files. In this case you will have children appear multiple times (as many times as they were co-resident with their parents).

Best wishes,
Understanding Society User Support Team


Updated by Understanding Society User Support Team almost 2 years ago

  • Private changed from Yes to No

Updated by Understanding Society User Support Team 3 months ago

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

Also available in: Atom PDF