The DHS Program User Forum: Merging data files » Linking child data with parentals information

Home » Data » Merging data files » Linking child data with parentals information (DHS 2015 Colombia)

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

Linking child data with parentals information [message #17743]

Mon, 20 May 2019 05:49

ren_sof
Messages: 4
Registered: January 2019

Member

Hello,

I am working on Colombia DHS 2015 data and need some help regarding the following issue:

I hava data where my unit of analysis are children that contains child´s information such as age, gender, number of sibling, birth order. I want to have parental information(education, occupation of mother and father/partner and household characteristics( place of residence, years living in the same place etc)

What I am doing is:

use "COPR72FL.DTA", clear
keep.....
sort hv001 hv002 hvidx
save dhsPR.dta, replace
clear

use "COBR72FL.DTA", clear
keep...
keep if b16>0 & b16<19
gen line_number_of_mother=v003
ren v001 hv001
ren v002 hv002
ren b16 hvidx
sort hv001 hv002 hvidx
save dhsBR.dta, replace
clear

use dhsPR.dta
merge 1:m hv001 hv002 hvidx using dhsBR.dta

***the lines above I guess link mothers with children in the same household****

However, I also need to link the father/partner information to this dataset.

Could anybody help me pleas? Any ideas? Am I doing something wrong?

I will appreciate your help.

Thanks

Report message to a moderator

Re: Linking child data with parentals information [message #17795 is a reply to message #17743]

Tue, 04 June 2019 15:32

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Please see the response below from Senior DHS Stata Specialist, Tom Pullum:

The attached program, with modifications, should do what you need with the Colombia 2015 DHS. It can easily be adapted for other countries or surveys.

Attachment: merge_PR_BR_IR_MR_do_3June2019.txt
(Size: 3.07KB, Downloaded 778 times)

Report message to a moderator

Re: Linking child data with parentals information [message #17800 is a reply to message #17795]

Wed, 05 June 2019 10:10

ren_sof
Messages: 4
Registered: January 2019

Member

Thanks for your help Tom.

I have another question. Could I replicate this excersise for 2005 and 2010 survey?

In 2005 and 2010 there is not a MR survey, however, I guess I can do the same but just linking the mothers information. In the IR there are a couple of questions about partners education among others. Could it be possible?

Thank you in advance.

Report message to a moderator

Re: Linking child data with parentals information [message #20222 is a reply to message #17795]

Sun, 11 October 2020 12:17

ronaldmusi
Messages: 3
Registered: June 2020

Member

Hello, Thanks for helping out. I am trying to replicate Table 2.1 0 Birth registration of children under age 5 for Zimbabwe DHS 2015. Using the attached code I have successfully coded other background variables. Now am having trouble with maternal variables eg education. which variable should I use for mothers education.
****constructing child registration variable
recode hv140 (0=0) (1/2=1) (else = 0) if hv102==1 & hv105<5, gen(birthreg)
label var birthreg " birth registered "
lab def birthreg 0 "not registered" 1 "registered"
lab val birthreg birthreg
svy:tab birthreg
tab birthreg[iweight=wt]

***Mother's highest educational level
recode v106 (0=0)(1=1)(2=2)(3=3) if hv102==1 & hv105<5, gen(Mothereducation222)
label var Mothereducation222 "Mother's highest educational level"
lab def Mothereducation2 0 "No education" 1 "Primary" 2 "Secondary" 3 "Higher"
lab val Mothereducation2 Mothereducation2
ta Mothereducation222 [iweight=wt]
tab Mothereducation22 birthreg [iweight=wt], row col

Report message to a moderator

Re: Linking child data with parentals information [message #20243 is a reply to message #20222]

Wed, 14 October 2020 18:53

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

I looked at that table and it does not include mother's education. Perhaps you are trying to expand the table to include education? The table uses data in the PR file. There is a variable ha61, mother's education, in the PR file. I believe that would be the variable to use. Otherwise, staying with just the PR file, you would go to hv118, the line number of the child's mother, and get hv106 from the mother's line.

Report message to a moderator

Previous Topic:	Merging Egypt 2000 KR and HW files
Next Topic:	Survey identifiers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Oct 31 08:58:26 Coordinated Universal Time 2025