The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Linking child data with parentals information (DHS 2015 Colombia)
Linking child data with parentals information [message #17743] Mon, 20 May 2019 05:49 Go to next message
ren_sof is currently offline  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




Re: Linking child data with parentals information [message #17795 is a reply to message #17743] Tue, 04 June 2019 15:32 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2025
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.
Re: Linking child data with parentals information [message #17800 is a reply to message #17795] Wed, 05 June 2019 10:10 Go to previous messageGo to next message
ren_sof is currently offline  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.
Re: Linking child data with parentals information [message #20222 is a reply to message #17795] Sun, 11 October 2020 12:17 Go to previous messageGo to next message
ronaldmusi is currently offline  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
Re: Linking child data with parentals information [message #20243 is a reply to message #20222] Wed, 14 October 2020 18:53 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2025
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.

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


Current Time: Mon Nov 30 21:21:47 Coordinated Universal Time 2020