Merging KR with PR for Ethiopia 2011 [message #14997] |
Thu, 24 May 2018 10:56 ![Go to next message Go to previous message](/theme/default/images/down.png) |
Yue_Chen
Messages: 2 Registered: May 2018 Location: Washington D.C.
|
Member |
|
|
Dear DHS Experts,
I am trying to replicate Table 10.7 Prevalence of diarrhoea in Ethiopia's 2011 report. However, I am having troubles merging PR dataset with KR. I have tried different ways but none of them works. I copied my codes as below.
use "/Ethiopia/2011/ETPR61DT/ETPR61FL.DTA", clear
keep hv001 hv002 hvidx hv201 hv205 hv225
rename hv001 v001
rename hv002 v002
rename hvidx b16
sort v001 v002 b16
save "/Ethiopia/2011/ETKR61DT/ETkKR61FLdiarrhoea.dta", replace
use "/Ethiopia/2011/ETKR61DT/ETKR61FL.DTA", clear
keep v001 v002 b16 v005 v008 b3 b5 h11 h11b v024 v025
sort v001 v002 b16
merge v001 v002 b16 using "/Ethiopia/2011/ETPR61DT/ETPR61FLdiarrhoea.dta"
Stata reports that the variables don't uniquely identify observations. If that's the case, which variables should I use instead? Thanks in advance!
Yue Chen
|
|
|