The DHS Program User Forum: Merging data files » Merging Child and Household data for a new user of Stata

Home » Data » Merging data files » Merging Child and Household data for a new user of Stata

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

Re: Merging Child and Household data for a new user of Stata [message #26634 is a reply to message #26629]

Wed, 12 April 2023 07:03

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

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

You should use the PR file rather than the HR file. The HR file has one very wide record for each household. The PR file has one record for each person in the household. In the PR file, the unique identifier for each person is hv001 hv002 hvidx. In the KR file, the identifier for each child is v001 v002 b16. Some children in the KR file have died or are not living with the mother, in which case b16 is NA or 0, and they are not in the PR file. There are also some children in the PR file who are not in the KR file, because their mothers have died or not living with the child. There have been many forum postings on this type of merge.

Report message to a moderator

[Message index]

		Merging Child and Household data for a new user of Stata By: rachelsb98 on Tue, 11 April 2023 14:59
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Wed, 12 April 2023 07:03
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Wed, 12 April 2023 08:10
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Wed, 12 April 2023 08:41
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Wed, 12 April 2023 08:43
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Wed, 12 April 2023 11:28
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Wed, 12 April 2023 15:06
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Wed, 12 April 2023 16:08
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Thu, 13 April 2023 07:15
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Thu, 13 April 2023 07:33
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Thu, 13 April 2023 08:07

Previous Topic:	Merging KR to MR OR (KR, IR, MR)
Next Topic:	How to merge KR and IR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Oct 13 17:35:19 Coordinated Universal Time 2025