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
|
|
|
|
|