The DHS Program User Forum: Merging data files » Merging KR and BR data files

Home » Data » Merging data files » Merging KR and BR data files

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Merging KR and BR data files [message #19274 is a reply to message #19180]

Wed, 20 May 2020 07:55

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

For all of the NFHS surveys, the identifiers for cases include hv024. There are other errors too. Try this:

.
use kr.dta 
drop if b16 ==. | b16==0 
rename v024 hv024
rename v001 hv001
rename v002 hv002
rename b16 hvidx
sort hv024 hv001 hv002 hvidx
save krtemp.dta 

use pr.dta 
sort hv024 hv001 hv002 hvidx
merge m:m using hv001 hv002 hv003 hvidx using krtemp.dta 

save krpr.dta

Report message to a moderator

[Message index]

		Merging KR and BR data files By: ask_ans_sri on Tue, 05 May 2020 16:25
		Re: Merging KR and BR data files By: Bridgette-DHS on Wed, 20 May 2020 07:55

Previous Topic:	Apply weight to merge data file
Next Topic:	How to match women to their husbands

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 26 09:28:16 Coordinated Universal Time 2024