The DHS Program User Forum: Merging data files » Linking parents to children

Home » Data » Merging data files » Linking parents to children

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Linking parents to children [message #2593 is a reply to message #2591]

Fri, 18 July 2014 17:36

Bridgette-DHS
Messages: 3230
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.

Report message to a moderator

[Message index]

		Linking parents to children By: nnalo on Fri, 18 July 2014 11:51
		Re: Linking parents to children By: Bridgette-DHS on Fri, 18 July 2014 17:36
		Re: Linking parents to children By: nnalo on Fri, 18 July 2014 19:26
		Re: Linking parents to children By: smileyc on Tue, 29 July 2014 00:51
		Re: Linking parents to children By: smileyc on Tue, 29 July 2014 00:51
		Re: Linking parents to children By: Bridgette-DHS on Tue, 29 July 2014 11:37
		Re: Linking parents to children By: smileyc on Tue, 29 July 2014 19:10
		Re: Linking parents to children By: Bridgette-DHS on Wed, 30 July 2014 08:56
		Re: Linking parents to children By: emre on Tue, 30 May 2017 04:34
		Re: Linking parents to children By: Bridgette-DHS on Tue, 30 May 2017 15:19

Previous Topic:	How to merge DHS databases of different countries
Next Topic:	Constructiong child data with parental information and other characteristics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Aug 12 00:30:03 Coordinated Universal Time 2025