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 previous 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




 
Read Message
Read Message
Read Message
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 May 30 01:17:32 Eastern Daylight Time 2020