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 #12840 is a reply to message #12835]

Fri, 21 July 2017 12:18

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

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

Ok -- your original query did say 2008, not 1998.

You can merge the PR and WI files using hhid and whhid, as follows:

use e:\DHS\DHS_data\WI_files\PHWI3AFL.dta, clear
rename whhid hhid
sort hhid
save e:\DHS\DHS_data\scratch\PHtemp.dta, replace

use e:\DHS\DHS_data\PR_files\PHPR3BFL.dta, clear
sort hhid
merge hhid using e:\DHS\DHS_data\scratch\PHtemp.dta

However, the KR file for this survey does not include b16. There have been several references to b16 in other forum posts. Without b16, you cannot merge the KR and PR files. Sorry about that.

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 09:40:11 Coordinated Universal Time 2024