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 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
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.
|
|
|
Goto Forum:
Current Time: Fri Aug 30 22:23:14 Coordinated Universal Time 2024
|