The DHS Program User Forum: Dataset use (other programs)

Home » Data » Dataset use (other programs) » Merging PR and KR file NFHS

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

Merging PR and KR file NFHS [message #25577]

Fri, 11 November 2022 12:23

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

Report message to a moderator

[Message index]

		Merging PR and KR file NFHS By: Lincoln on Fri, 11 November 2022 12:23
		Re: Merging PR and KR file NFHS By: Bridgette-DHS on Mon, 14 November 2022 09:47
		Re: Merging PR and KR file NFHS By: Lincoln on Tue, 15 November 2022 10:32

Previous Topic:	respondents not visiting health facility
Next Topic:	NFHS-5 Disability and health seeking

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 12:56:46 Coordinated Universal Time 2024