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

Guinea 1999 DHS: merging KR onto PR [message #30619]

Wed, 08 January 2025 20:31

csalemi
Messages: 4
Registered: November 2024

Member

I'm trying to merge datasets from the Guinea 1999 DHS. Specifically, I want to match child health indicators in the KR recode to their record in the PR recode. The KR recode is missing the b16 variable, which identifies the child's line number. What other variable can I use to perform this merge, and what additional considerations need to be accounted for?

Report message to a moderator

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: 926
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

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

Tue, 14 January 2025 20:35

csalemi
Messages: 4
Registered: November 2024

Member

So to be clear: there is no b16 equivalent in the KR file for Guinea 1999?

Report message to a moderator

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

Wed, 15 January 2025 11:27

Janet-DHS
Messages: 926
Registered: April 2022

Senior Member

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

That is correct. There are only a few surveys with this problem, and this is one of them.

Report message to a moderator

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

Wed, 15 January 2025 12:15

csalemi
Messages: 4
Registered: November 2024

Member

Thank you. For my research, I wanted to be able to say with confidence that we excluded this country-year because it was missing a key matching variable. Thanks to this exchange, I can now say that without it being a guess.

A list of all countries and years with matching issues (ex: missing B16) would be a helpful resource for researchers - does such a list exist?

Report message to a moderator

Previous Topic:

Ghana DHS 2022

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jan 17 18:30:47 Coordinated Universal Time 2025