| 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
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
