The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Guinea 1999 DHS: merging KR onto PR
Re: Guinea 1999 DHS: merging KR onto PR [message #30649 is a reply to message #30619] Tue, 14 January 2025 12:02 Go to previous messageGo to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 921
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.
 
Read Message
Read Message
Read Message
Previous Topic: Ghana DHS 2022
Goto Forum:
  


Current Time: Wed Jan 15 01:05:56 Coordinated Universal Time 2025