| Merging women's file with Household File [message #1374] |
Wed, 19 February 2014 14:38  |
Kwesi.Nkrumah
Messages: 4
Registered: March 2013
Location: Ghana
|
Member |
|
|
Dear Users,
I am trying to merge the women's file with the household file. The women's file is my base. I used the following code after reading the merge guidelines from the Measure DHS website. see the code below:
use "/Users/Kwesi/Downloads/GHHR41DT/GHHR41FL.DTA"
keep hhid hv000 hv001 hv002 hv003 hv003 hv213 hv216 hv217 hv221 hv220 hv219
ren hv001 v001
ren hv002 v002
gen unique=v001*1000
replace unique=unique+v002
sort unique
save "/Users/Kwesi/Downloads/GHWI41FL-house.DTA", replace
clear
use "/Users/Kwesi/Documents/Document General/Main Documents/Latest Buckup 29 JAn/Academic Documents/WIP and Project papers/Institutional Projects/AERC/Maternal Health Paper/Data/Ghana-1998.DTA"
keep caseid v001 v002 v003 v005 v012 v024 v025 v101 v106 v107 v113 v115 ///
v116 v130 v131 v133 v136 v137 v138 v149 v150 v151 v152 bord_01 ///
v302 m13_1 m14_1 m15_1 h2_1 h3_1 h4_1 h5_1 h6_1 h7_1 h8_1 h9_1 ///
h0_1 v701 v702 v715 v729 v730
gen unique=v001*1000
replace unique=unique+v002
sort unique
merge 1:m unique using "/Users/Kwesi/Downloads/GHWI41FL-house.DTA"
I got a feedback from Stata that unique does not uniquely identify the variables in the master. I decided to drop the constructed unique variables and its place use v001 and v002, I got the same feedback. Please can you help.
Regards
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
