The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Height and Weight Files

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

Re: Height and Weight Files [message #3305 is a reply to message #3283]

Wed, 19 November 2014 14:36

rejone4@emory.edu
Messages: 8
Registered: November 2014
Location: United States

Member

thanks that worked well for most datasets. However there are a few HW files that have hwhhid as the variable for case identification.

For example, Armenia 2005 has this type of setup. When I used the following code:

*rename variables and sort data for merging
ren hwhhid caseid
ren hwline midx
sort caseid midx
save "AMHW01_temp.dta", replace

*sort the children's recode data and then merge
use "H:\Thesis\Armenia_2010\Armenia_2005(V)\AMKR42FL.dta", clear
sort caseid midx
merge 1:1 caseid midx using "H:\Thesis\Armenia_2010\Armenia_2005(V)\AMHW01_temp.dta"

It did not match the data anymore. Is there something that has to be done differently with these files?

Report message to a moderator

[Message index]

		Height and Weight Files By: rejone4@emory.edu on Mon, 17 November 2014 18:00
		Re: Height and Weight Files By: Trevor-DHS on Mon, 17 November 2014 18:10
		Re: Height and Weight Files By: rejone4@emory.edu on Wed, 19 November 2014 14:36
		Re: Height and Weight Files By: Trevor-DHS on Wed, 19 November 2014 23:00
		Re: Height and Weight Files By: arenaud on Wed, 14 January 2015 13:28
		Re: Height and Weight Files By: Bridgette-DHS on Wed, 14 January 2015 15:48

Previous Topic:	Correct numbers for merging the household and individual files of the 2001 DHS Nepal
Next Topic:	Merging Household+Female+Male files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jan 10 18:04:39 Coordinated Universal Time 2025