The DHS Program User Forum: Child Health » Guinea 1999 DHS: merging KR onto PR

Home » Topics » Child Health » Guinea 1999 DHS: merging KR onto PR

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

Re: Guinea 1999 DHS: merging KR onto PR [message #30649 is a reply to message #30619]

Tue, 14 January 2025 12:02

Janet-DHS
Messages: 937
Registered: April 2022

Senior Member

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

Unfortunately, it is not possible to identify the correct child in the PR file when b16 is missing from the KR file. We have tried alternatives and they are not reliable. However, it's likely that the variables you want are the household-level variables on water and sanitation, etc. that are on the mother's record in the PR file. You would match v001 v002 v003 for each child in the KR file with hv001 hv002 hvidx in the PR file. This would be a 1:m or m:1 merge because a woman can have more than one child in the KR file.

Note that the child's record in the KR file already includes most of the mother's variables that are in the IR file.

Report message to a moderator

[Message index]

		Guinea 1999 DHS: merging KR onto PR By: csalemi on Wed, 08 January 2025 20:31
		Re: Guinea 1999 DHS: merging KR onto PR By: Janet-DHS on Tue, 14 January 2025 12:02
		Re: Guinea 1999 DHS: merging KR onto PR By: csalemi on Tue, 14 January 2025 20:35
		Re: Guinea 1999 DHS: merging KR onto PR By: Janet-DHS on Wed, 15 January 2025 11:27
		Re: Guinea 1999 DHS: merging KR onto PR By: csalemi on Wed, 15 January 2025 12:15

Previous Topic:	Ghana DHS 2022
Next Topic:	Managing DHS datasets, Ghana

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Dec 19 05:54:08 Coordinated Universal Time 2025