The DHS Program User Forum: Child Health » Merging Household file to children file

Home » Topics » Child Health » Merging Household file to children file (merging household and child files)

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

Merging Household file to children file [message #16153]

Mon, 12 November 2018 11:47

kbrindle
Messages: 3
Registered: November 2018

Member

Hello,

I am having issues merging the household file to the childrens file. I am only interesting in merging because there is a district-level variable in household that is not in childs data file. I used the following code, but this did not seem to match effectively in Stata.

(Master is child file, and using file is household)
gen hh_uniqID (in household file) = (hv001*100)+hv002

gen hh_uniqID (in child file) = (v001*100)+v002

merge m:1 hh_uniqID using "file location"

I've seen the website in merging the data sets, https://dhsprogram.com/data/Merging-Datasets.cfm however, following this does not allow to merge properly with children and household data.

Report message to a moderator

[Message index]

		Merging Household file to children file By: kbrindle on Mon, 12 November 2018 11:47
		Re: Merging Household file to children file By: Liz-DHS on Mon, 04 February 2019 12:51

Previous Topic:	Children immunisation
Next Topic:	Coefficients are large in multilevel analysis

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Dec 22 07:46:06 Coordinated Universal Time 2024