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

Merging the child, household and wealth file for Philippines 1998 [message #12829]

Wed, 19 July 2017 16:59

chlansangan
Messages: 6
Registered: July 2017

Member

Hello,

I'm trying to merge the child, household and wealth file into one file for analysis.
What have I done so far is to use country code and phase, cluster number and household number to merge the child and household file together.
Then, I use the household id number to merge the child&household file with the wealth file.

Whenever I do this, I lose the variables I need from the wealth file. I've been working on this for a few months now and still cannot figure out what's wrong.
I've tried merging the files different ways and I still lose variables that I require to do my analysis.

Thanks,
Charmaine

[Updated on: Wed, 19 July 2017 17:20]

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 09:27:16 Coordinated Universal Time 2024