The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use (other programs) » Merging PR and KR file NFHS
Merging PR and KR file NFHS [message #25577] Fri, 11 November 2022 12:23 Go to previous message
Lincoln is currently offline  Lincoln
Messages: 31
Registered: July 2022
Member
Hi, I am having some problems with merging NFHS-5 file merging PR with KR file: Here are codes and result:

PR data
drop if hc60>30
rename hvidx cline
rename v001 clusterline
rename hv001 clusterline
rename hv002 hhline
rename hv024 state
rename hc60 motherline
sort cline clusterline hhline state motherline

. save "/temp

. clear

. use "KR data"

drop if b16==0
drop if b16==.
rename b16 cline
rename v001 clusterline
rename v002 hhline
rename v024 state
rename v003 motherline
sort cline clusterline hhline state motherline
. merge 1:1 cline clusterline hhline state motherline using
"temp
(variable motherline was byte, now int to accommodate using data's values)

Result Number of obs
-----------------------------------------
Not matched 734
from master 727 (_merge==1)
from using 7 (_merge==2)

Matched 221,256 (_merge==3)
-----------------------------------------


Please help.

Regards
Lincoln
 
Read Message
Read Message
Read Message
Previous Topic: respondents not visiting health facility
Next Topic: NFHS-5 Disability and health seeking
Goto Forum:
  


Current Time: Sun Jul 21 02:28:13 Coordinated Universal Time 2024