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: 3
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: 1677
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 message
ren_sof is currently offline  ren_sof
Messages: 3
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.
Previous Topic: Merging HW and BR in Zambia 2001-02
Next Topic: How to combine male and women data for 3 rounds of DHS Pakistan?
Goto Forum:
  


Current Time: Sat Oct 19 14:09:30 Eastern Daylight Time 2019