Project

General

Profile

Support #2069

Match children information with parental information

Added by Giovanni Greco 2 months ago. Updated 2 months ago.

Status:
Feedback
Priority:
Normal
Category:
Data documentation
Start date:
03/06/2024
% Done:

50%


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.

#1

Updated by Understanding Society User Support Team 2 months ago

  • 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

#2

Updated by Understanding Society User Support Team 2 months ago

  • 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

#3

Updated by Giovanni Greco 2 months ago

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

#4

Updated by Understanding Society User Support Team 2 months ago

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