The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging KR with PR for Ethiopia 2011
Merging KR with PR for Ethiopia 2011 [message #14997] Thu, 24 May 2018 10:56 Go to previous message
Messages: 2
Registered: May 2018
Location: Washington D.C.
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
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: merging MWIR7IDT.DTA with Variable hml19
Next Topic: Merging Women-Men-HIV Data: Different Countries, Different Years
Goto Forum:

Current Time: Tue Mar 31 12:23:24 Eastern Daylight Time 2020