The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Merging Household file to children file (merging household and child files)
Merging Household file to children file [message #16153] Mon, 12 November 2018 11:47 Go to next message
kbrindle is currently offline  kbrindle
Messages: 3
Registered: November 2018

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, however, following this does not allow to merge properly with children and household data.
Re: Merging Household file to children file [message #16591 is a reply to message #16153] Mon, 04 February 2019 12:51 Go to previous message
Messages: 1516
Registered: February 2013
Senior Member
Dear User, check out this link
Previous Topic: Children immunisation
Next Topic: Coefficients are large in multilevel analysis
Goto Forum:

Current Time: Thu May 23 16:15:03 Coordinated Universal Time 2024