Support #2069
Match children information with parental information
Added by Giovanni Greco 2 months ago.
Updated about 2 months ago.
Category:
Data documentation
Description
Good morning Users.
For my Master thesis, I am using data on children, and I need parental information (their household ID and their household income) to be matched into childrens data. Probably the family matrix is of great help, but I am struggling to figure out how to do it in Stata.
Has there been anyone with a similar challenge?
Thank you in advance.
- Category set to Data documentation
- Status changed from New to In Progress
- % Done changed from 0 to 10
- Private changed from Yes to No
Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can. We aim to respond to simple queries within 48 hours and more complex issues within 7 working days.
Best wishes,
Understanding Society User Support Team
- Status changed from In Progress to Feedback
- % Done changed from 10 to 50
Hello Giovanni,
Please take a look at the Data management syntax files section. Here, you can find syntax for performing common data management tasks such as merging two files and matching information of respondent and their partner using Understanding Society data files.
Specifically, I recommend reviewing the “Matching co-resident parents’ information”, which links respondents (of any age) with information about their co-resident parents and the “Distributing household level information to the individual level”, which distributes household level information to individuals in those households.
I hope this information is helpful.
Best wishes,
Roberto Cavazos
Understanding Society User Support Team
Dear Roberto,
Thank you very much for your help.
I need to merge parental data into children's information also when children have left the parental house. I had a look at the syntax you suggest. In this regard, I wanted to ask whether there is a way to modify this syntax in order to allow matching also information for children that are no longer living in the same household of the parents. Otherwise, is there another syntax for this specific goal?
Thank you very much.
Best wishes,
Giovanni Greco
Hello Giovanni,
You would need first to identify children that have left the parental house. I think the best approach will be using file xhhrel (family matrix) which identifies all family relationships across the Study even if they are not co-residents.
The xhhrel file creates an individual level cross-wave file of all sample members (those who were ever enumerated as part of the study) that contains familial relationship identifiers reported over the survey period for each sample member. This file also contains an origin household identifier variable (osm_hh) which identifies the household they come from, so that sample members who are connected can be identified (either because they were co-resident at some point or were co-resident with individuals who were co-resident with each other).
For further details please refer to Family Matrix User Guide
I hope this information is helpful.
Best wishes,
Roberto Cavazos
Understanding Society User Support Team
Also available in: Atom
PDF
Updated by 
Updated by