Project

General

Profile

Support #2081

Merging parents (or carer) information to youth data

Added by Lydia Sung 24 days ago. Updated 21 days ago.

Status:
Feedback
Priority:
High
Assignee:
Understanding Society User Support Team
Category:
Data management
Start date:
04/06/2024
% Done:

80%

Description

Hi Understanding Society team,

I am studying the relationship between type of rental housing (ie private vs social) and youth psychological well-being as well as the role housing quality plays in it.

I am using Wave BH18 data and have successfully:
- merged hhresp and indresp by hidp ( merged01 ) using the suggested syntax of "DISTRIBUTING HOUSEHOLD LEVEL INFORMATION TO THE INDIVIDUAL LEVEL"
- filtered both merged01 and youth to only those living in rented housing

However, in order to perform further analysis, I need to bring merged01 and youth together in order to look into potential confounders such as SES, HH and parental characteristics.

Could you please advise what might be the best way to do it? Thank you.

P.S. I've seen earlier posts about matching parents to children information, but the link to those syntax is broken.
P.S.2 I am using R.

#1

Updated by Understanding Society User Support Team 21 days ago

  • Category changed from Data analysis to Data management
  • Status changed from New to Feedback
  • % Done changed from 0 to 80
  • Private changed from Yes to No

Hello,

It looks like your analysis is at the youth level, so I'd suggest starting from the youth file and then:

1) you can link to hhresp using br_hidp (it looks like you've already done this successfully)
2) you can link to parents using br_fnspno (father's pno) and br_mnspno (mother's pno) - e.g. you can open the indresp dataset with the selection of variables of interest, rename br_pno to br_fnspno/br_mnspno and then link that new data frame to the youth file, if you keep only the matched observations in the youth file you will get a youth file with the linked parental informational, for more information I'd recommend checking our online Introduction to UKHLS course (https://open.essex.ac.uk/course/view.php?id=221 , example 7)
3) you can also aggregate individual level information to get a household level information (e.g., if you wanted to get the higher education of two parents), again, please check the course linked above (example 5)

I hope this helps.

Best wishes,
Piotr Marzec
UKHLS User Support

Also available in: Atom PDF