Support #2038
open
Merging family level and individual level data
100%
Description
Hi,
I am looking to create a panel data set using the main survey from Understanding society. Most variables I need are contained within the indresp file, however a couple I want are in the hhresp file. Is there a way to create a panel data set, i.e using multiple years of data, with a data set combining both hhresp and indresp variables.
Thanks.
Updated by Understanding Society User Support Team 11 months ago
- Category set to Data management
- Status changed from New to Feedback
- % Done changed from 0 to 80
Hi Ted,
You can proceed in two steps:
1) linking the household level data to the individual level data for each wave using the w_hidp variable - for that task, you may find useful the code in "Distributing household level information to the individual level" available here: https://www.understandingsociety.ac.uk/documentation/mainstage/syntax/
2) and then linking the individuals across waves using the pidp variable - you can use the code from the "Merging individual files across waves into wide format" and the "Merging individual files across waves into wide format" files (https://www.understandingsociety.ac.uk/documentation/mainstage/syntax/)
Linking households across waves is not possible as there is no longitudinal household identifier in UKHLS (hidp changes in each wave even if the household stays exactly the same).
Best wishes,
Piotr Marzec,
UKHLS User Support
Updated by Understanding Society User Support Team 11 months ago
- Private changed from Yes to No
Updated by Understanding Society User Support Team 10 months ago
- Status changed from Feedback to Resolved
- % Done changed from 80 to 100