The DHS Program User Forum: Merging data files » Merging the child, household and wealth file for Philippines 1998

Home » Data » Merging data files » Merging the child, household and wealth file for Philippines 1998

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

Re: Merging the child, household and wealth file for Philippines 1998 [message #12885 is a reply to message #12882]

Fri, 28 July 2017 07:26

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Another response from Senior DHS Stata Specialist, Tom Pullum:

The reason why you were able to merge the KR file with the HR file is that the HR file has one record per household. This is a very wide file--that is, the records are very long and each record contains information about everyone in the household. The people in the household have subscripts for their individual-level information. What you did in that merge was not very useful. The merged record for each child would have attached to it all the information about all the people in the household.

A much more useful merge, and the one I thought you were trying to do, was with the KR and PR files. The PR file is long, rather than wide, with one record for each person in the household. Each record includes information about the household as a whole, such as water and sanitation, but the individual-level information is just about the one individual. For that file you need to match b16 in the KR file with hvidx in the PR file. If you do not have b16, then you are stuck. Fortunately, this was realized about 20 years ago and the KR files since then include b16.

Report message to a moderator

[Message index]

		Merging the child, household and wealth file for Philippines 1998 By: chlansangan on Wed, 19 July 2017 16:59
		Re: Merging the child, household and wealth file for Philippines 1998 By: Bridgette-DHS on Thu, 20 July 2017 07:16
		Re: Merging the child, household and wealth file for Philippines 1998 By: chlansangan on Thu, 20 July 2017 12:31
		Re: Merging the child, household and wealth file for Philippines 1998 By: Bridgette-DHS on Fri, 21 July 2017 12:18
		Re: Merging the child, household and wealth file for Philippines 1998 By: chlansangan on Tue, 25 July 2017 14:41
		Re: Merging the child, household and wealth file for Philippines 1998 By: Bridgette-DHS on Tue, 25 July 2017 17:28
		Re: Merging the child, household and wealth file for Philippines 1998 By: chlansangan on Thu, 27 July 2017 17:09
		Re: Merging the child, household and wealth file for Philippines 1998 By: Bridgette-DHS on Fri, 28 July 2017 07:26
		Re: Merging the child, household and wealth file for Philippines 1998 By: chlansangan on Tue, 01 August 2017 13:55
		Re: Merging the child, household and wealth file for Philippines 1998 By: Bridgette-DHS on Wed, 02 August 2017 12:47
		Re: Merging the child, household and wealth file for Philippines 1998 By: chlansangan on Wed, 16 August 2017 13:41
		Re: Merging the child, household and wealth file for Philippines 1998 By: Bridgette-DHS on Fri, 17 November 2017 12:21

Previous Topic:	DRC merge individuals records contained in household data to child data
Next Topic:	Thoughts on pooling surveys from single country

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 26 08:33:46 Coordinated Universal Time 2024