The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging KR and BR data files
Merging KR and BR data files [message #19180] Tue, 05 May 2020 16:25 Go to previous message
ask_ans_sri is currently offline  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.
 
Read Message
Read Message
Previous Topic: Apply weight to merge data file
Next Topic: How to match women to their husbands
Goto Forum:
  


Current Time: Thu Dec 26 09:21:30 Coordinated Universal Time 2024