Home » Data » Merging data files » Merge PR and KR in wave 3, b16 does not exist
| Re: Merge PR and KR [message #21769 is a reply to message #14951] |
Wed, 16 December 2020 06:34  |
ask_ans_sri
Messages: 2
Registered: June 2018
Location: DELHI
|
Member |
|
|
I have used the following syntax for merging PR and KR files on NFHS-4
use kr.dta
rename (v001 v002 b16)(hv001 hv002 hvidx)
drop if hvidx==0 | hvidx==.
save kr.dta
use pr.dta
sort hv001 hv002 hvidx
merge m:m hv001 hv002 hvidx using kr.dta
The results are as follows
Result # of obs.
-----------------------------------------
not matched 2,624,197
from master 2,624,194 (_merge==1)
from using 3 (_merge==2)
matched 244,855 (_merge==3)
I am working on KR file. I have estimated stunting varibale from KR file and need some variables from PR file.
The stunting estimate is matching with the reported figure.
. ta child_stunt [aw=wt]
child_stunt Freq. Percent Cum.
0 143,158.22 61.59 61.59
1 37,867.5617 16.29 77.88
2 51,414.222 22.12 100.00
Total 232,440 100.00
in child_stunt 1 is below -300.
But I am having issue of tallying the frequencies. The frequency I am getting is not matching with the report (page 337).
Please do let me know if I am doing anything wrong.
Thanks in advance.
|
|
|
|
Current Time: Tue Dec 3 22:47:33 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
