The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Linking parents to children
Re: Linking parents to children [message #2593 is a reply to message #2591] Fri, 18 July 2014 17:36 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3214
Registered: February 2013
Senior Member
Following is a response from Senior Data Processing Specialist, Ladys Ortiz:

First: Generate a mother/father data set using (hhid + hv112/hv114) as the identifier, plus any other mother/father's variables you want to analyze as age, education, etc. (using the household member recode data NGPR???.DAT)

Second: Generate a children aged 5-15 data file using hhid+hidx plus any children's variable you want to analyze (do not forget to include their mothers/fathers line number (hv112/hv114)

Third: Merge the parent's data file (mother/father) to the children (aged 5-15) using as an ID: "hhid+hv112/hv114"

Note: if the parents are not living in the household or are dead, the information about parents will be missing.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to merge DHS databases of different countries
Next Topic: Constructiong child data with parental information and other characteristics
Goto Forum:
  


Current Time: Sun Dec 22 09:52:44 Coordinated Universal Time 2024