The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Linking parents to children
Linking parents to children [message #2591] Fri, 18 July 2014 11:51 Go to next message
nnalo is currently offline  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.
Re: Linking parents to children [message #2593 is a reply to message #2591] Fri, 18 July 2014 17:36 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
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.
Re: Linking parents to children [message #2595 is a reply to message #2593] Fri, 18 July 2014 19:26 Go to previous messageGo to next message
nnalo is currently offline  nnalo
Messages: 5
Registered: July 2014
Member
Thank you so much!!
Re: Linking parents to children [message #2634 is a reply to message #2595] Tue, 29 July 2014 00:51 Go to previous messageGo to next message
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
Re: Linking parents to children [message #2635 is a reply to message #2595] Tue, 29 July 2014 00:51 Go to previous messageGo to next message
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
Re: Linking parents to children [message #2636 is a reply to message #2635] Tue, 29 July 2014 11:37 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
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.
Re: Linking parents to children [message #2640 is a reply to message #2636] Tue, 29 July 2014 19:10 Go to previous messageGo to next message
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.
Re: Linking parents to children [message #2642 is a reply to message #2640] Wed, 30 July 2014 08:56 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
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
Re: Linking parents to children [message #12496 is a reply to message #2593] Tue, 30 May 2017 04:34 Go to previous messageGo to next message
emre is currently offline  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?
Re: Linking parents to children [message #12503 is a reply to message #12496] Tue, 30 May 2017 15:19 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3013
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

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: Tue Mar 19 03:54:34 Coordinated Universal Time 2024