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

Linking parents to children [message #2591]

Fri, 18 July 2014 11:51

nnalo
Messages: 5
Registered: July 2014

Member

Hello,
I am working with DHS 2013, Nigeria data set. I am having trouble linking the parents education level with the children from the household member recode. How do I identify the parents that have children aged 5-15 years.
I have already generated a new variable for mother's age and father's age using the mother's line number and father's line number.
i.e
sort hhid hvidx
>
> Next, generate variables with the mother's and father's age.
>
> . by hhid: gen mage = hv105[hv112]
> . by hhid: gen fage = hv105[hv114]

Thank you.

Report message to a moderator

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

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

Fri, 18 July 2014 19:26

nnalo
Messages: 5
Registered: July 2014

Member

Thank you so much!!

Report message to a moderator

Re: Linking parents to children [message #2634 is a reply to message #2595]

Tue, 29 July 2014 00:51

smileyc
Messages: 14
Registered: June 2014

Member

Hello, I almost have the same case but the I am more interested on parents of children 15-24 years of age. Is there a way I can generate the mother and father years of schooling using the IR, MR, PR, and KR DHS recodes?

Would appreciate your advice on this. Thank you

Report message to a moderator

Re: Linking parents to children [message #2635 is a reply to message #2595]

Tue, 29 July 2014 00:51

smileyc
Messages: 14
Registered: June 2014

Member

Hello, I almost have the same case but I am more interested on parents of children 15-24 years of age. Is there a way I can generate the mother and father years of schooling using the IR, MR, PR, and KR DHS recodes?

Would appreciate your advice on this. Thank you

Report message to a moderator

Re: Linking parents to children [message #2636 is a reply to message #2635]

Tue, 29 July 2014 11:37

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from Senior Data Processing Specialist, Noureddine Abderrahim:

The DHS standard questionnaire asks four questions on survivorship and residence of parents, in columns 12 through 15 of the household schedule. Columns 12 and 14 determine whether the mother and the father live in the household or are visitors. In case the mother or the father is alive and lives in the household, columns 13 and 15 records the line number(s) of the parent(s).

You may use these two questions to relate the child to his/her parent. However, these questions (12 through 15) are only asked for children 0-17 years old. You can therefore generate the mother's and father's years of schooling, only for children 0-17 years old. You will be missing that information for all children 18-24 years old.

Report message to a moderator

Re: Linking parents to children [message #2640 is a reply to message #2636]

Tue, 29 July 2014 19:10

smileyc
Messages: 14
Registered: June 2014

Member

Dear Bridgette,

Thank you for this useful information. I have seen the question on survivorship and residence of biological parents and yes you're right that the questions is being asked to children 0-17 years old only.
I thought I can use the women's (individual recode) to link the mother with their children recorded in the household member's recode. Same as for men. Can this be possible?

Thank you.

Report message to a moderator

Re: Linking parents to children [message #2642 is a reply to message #2640]

Wed, 30 July 2014 08:56

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

There are several discussions on the user forum for merging DHS datasets please see one such discussion at:

http://userforum.dhsprogram.com/index.php?t=msg&th=1342& amp;goto=2365&S=8121847911c49a4f9fd2a7730e60aaa3#msg_236 5

Report message to a moderator

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

Tue, 30 May 2017 04:34

emre
Messages: 3
Registered: May 2017
Location: Ankara Turkey

Member

Hi, I have the same problem. Which data set should I use at the second step?

Report message to a moderator

Re: Linking parents to children [message #12503 is a reply to message #12496]

Tue, 30 May 2017 15:19

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

Here are some lines for doing this merge. I used the Cambodia 2014 data files. You need to change the paths as well as the files. I have added in some variables (child_in_PR_file, etc.) that may help with the interpretation but are not really necessary. Good luck....

set more off
use e:\DHS\DHS_data\IR_files\KHIR72FL.dta, clear
sort v001 v002 v003
gen in_IR_file=1
save e:\DHS\DHS_data\scratch\temp.dta, replace
ta
use e:\DHS\DHS_data\PR_files\KHPR72FL.dta, clear
rename hv001 v001
rename hv002 v002
rename hv112 v003
tab v003,m
drop if v003==.
gen child_in_PR_file=1
gen mother_in_hh=1
replace mother_in_hh=0 if v003==0

sort v001 v002 v003
merge v001 v002 v003 using e:\DHS\DHS_data\scratch\temp.dta

tab1 v003 *_file mother* _merge,m
drop if _merge==2

tab _merge mother_in_hh,m

drop _merge

* This file has one record per child
* hv variables refer to the child, v variables refer to the mother
* If the child's mother is not in the household, then mother_in_hh=0

Report message to a moderator

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: Fri Oct 31 16:44:44 Coordinated Universal Time 2025