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 #12873 is a reply to message #12870]

Tue, 25 July 2017 17:28

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

When doing a merge you can almost always ignore v000. The id for a person in the PR file is hv001 hv002 hvidx, which will match with a woman in the IR file using v001 v002 v003 or with a child in the KR file using v001 v002 b16, but in this survey you do not have b16. You must have b16 to get a merge with hvidx, and the older files do not have b16.

The WI file has one record per household. The HR file has one record per household. I can't tell whether you are referring to the HR file or the PR file as the "household" file. You CAN merge the WI file with the HR file or the KR file with the HR file, without using the line numbers. Please tell me whether you were using the HR file or the PR file.

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: Wed Dec 25 21:12:28 Coordinated Universal Time 2024