The DHS Program User Forum: Merging data files » Merge PR and KR in wave 3, b16 does not exist

Home » Data » Merging data files » Merge PR and KR in wave 3, b16 does not exist

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

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.

Report message to a moderator

[Message index]

		Merge PR and KR in wave 3, b16 does not exist By: nibiti on Sat, 19 May 2018 12:59
		Re: Merge PR and KR in wave 3, b16 does not exist By: Bridgette-DHS on Mon, 21 May 2018 12:58
		Re: Merge PR and KR in wave 3, b16 does not exist By: nibiti on Tue, 22 May 2018 08:28
		Re: Merge PR and KR in wave 3, b16 does not exist By: Bridgette-DHS on Thu, 14 June 2018 11:06
		Re: Merge PR and KR in wave 3, b16 does not exist By: kingx025 on Sun, 08 July 2018 23:16
		Re: Merge PR and KR in wave 3, b16 does not exist By: zelalem on Thu, 28 November 2019 07:27
		Re: Merge PR and KR By: ask_ans_sri on Wed, 16 December 2020 06:34

Previous Topic:	Survey identifiers
Next Topic:	Merging household and women's individual data Myanmar 2015-2016

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Apr 28 16:50:47 Coordinated Universal Time 2024