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

Re: Merging PR and KR file NFHS [message #25587 is a reply to message #25577]

Mon, 14 November 2022 09:47

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

I tried this merge with my own code and got the same results, 727 and 7 non-matches. I also tried it with hv112 in place hc60, which gave MORE non-matches. I also tried including age in months (hc1 in the PR file and hw1 in the KR file), which again gave 727 and 7 non-matches.

If the number of cases with _merge=1 were about the same as the number with _merge=2, then it would be possible that something is keeping them from merging with each other. However, almost all of the unmatched children (727) are in the KR file only (_merge=1). There are only 7 children who are in the PR file only (_merge=2). Even if you could match the 7 cases with _merge=2, there would still be 720 unmatched cases with _merge=1. I don't think there's anything you can do to improve the merge. It only affects about 1/3 of one percent of the children in the PR file.

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: Tue Sep 16 09:25:30 Coordinated Universal Time 2025