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
Read Message
Read Message
Previous Topic: Merging Egypt 2000 KR and HW files
Goto Forum:
  


Current Time: Sat Nov 28 17:19:53 Coordinated Universal Time 2020