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

Merging KR and BR data files [message #19180]

Tue, 05 May 2020 16:25

ask_ans_sri
Messages: 2
Registered: June 2018
Location: DELHI

Member

I have tried to replicate table no. 10.12 in NFHS-4, India report. For this I have merged KR and PR by following syntax

use kr.dta

rename caseid hhid
rename (v000 v001 v002 v003)(hv001 hv002 hv003)
rename b16
drop if b16 ==. | b16==0

save kr.dta

use pr.dta

merge m:m using hv001 hv002 hv003 hvidx using kr.dta

save krpr.dta

I am unable to match frequencies with the reported frequency on table 10.12. Even though I got same percentage with KR file, but unable to match frequencies. Please do help me.

I have used all the weights and filtered hv103 ==1 and hv102==1. But still not able to match. Please help me.

Report message to a moderator

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

Wed, 20 May 2020 07:55

Bridgette-DHS
Messages: 3220
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

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: Mon Jan 13 22:38:10 Coordinated Universal Time 2025