Merging BHPS and Understanding Society stata
we are working on our Master project using BHPS panel data, and we wanted to add the Understanding Society database to increase our panel. But we cannot find the way to merge both types of datasets. We though PID was an unique identificator and did not change in the two different surveys, but we have no single individual in wave 2 of Understanding Society that coincides with any individual in any wave 14 - 18 of BHPS. I am sure we are missunderstanding something, so it would be great if we could get some help on this. I am sending a file in which it is explained how to merge them: at the end of page 2 it says:
It is very easy to identify the BHPS sample members in Understanding Society as the unique cross-wave person identifiers in the BHPS, pid, are provided with each UKHLS data file (in Wave 2).
We would be very grateful if we could get some advice on how to keep on with this.
Thank you so much in advance.
Updated by Gundi Knies almost 4 years ago
- File usersupport_no774.log usersupport_no774.log added
- Category set to Data analysis
- Status changed from New to In Progress
- Assignee set to Sonia Turrero
- Priority changed from Urgent to Normal
- % Done changed from 0 to 50
in general terms, I cannot confirm your finding that none of the BHPS members in Wave 14-18 are included in Understanding Society Wave 2. I have checked using a simple mini programme that merges BHPS sample members in UKHLS Wave 2 with individuals in BHPS W14, see log file attached. I would not expect to see very different numbers of matches for other waves of BHPS data.
We can only speculate why you find no matches. Perhaps you have implemented strict sample restrictions on the BHPS before trying to merge to Understanding Society w2 cases? Then the mismatches may be genuine, in that none of the people you wish to track participated in the UKHLS. But there may be other issues with your code/ data generation.
Hope this helps,