The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Ethiopia 2000 wealth indicator merging
Ethiopia 2000 wealth indicator merging [message #4222] Mon, 20 April 2015 16:43 Go to next message
annfitz is currently offline  annfitz
Messages: 5
Registered: April 2015
Member
Hi

has anyone been able to merge the wealth data from ethiopia 2000 into the individual recode file in stata, i get an error message, tried merging on variables v001 and v002 , after creating these from whhid and renaming qnd declaring the variables to be the same across different files, but unfortunately this didnt work as not all the results are unique, eg, for 1101, this could be 1 101 or 11 01 or 101 1

If anyone has any suggestions as to how i can merge the wealth data it is much appreciated


Dr Ann fitzmaurice
Re: Ethiopia 2000 wealth indicator merging [message #4224 is a reply to message #4222] Mon, 20 April 2015 20:14 Go to previous messageGo to next message
Reduced-For(u)m
Messages: 292
Registered: March 2013
Senior Member

Looking over an old do file i just did this:

*begin using the individual recode (I used child, but should still work)
use child.dta

*generate the variable that corresponds to the wealth data
gen whhid = substr(caseid, 1, 12)

*merge
merge m:1 whhid using wealth.dta

But that is merging from many (in the child data) to one (in the wealth data). Are you starting with the individual data, generating whhid there, and then merging in the wealth data? Or are you trying to go the other way?
Re: Ethiopia 2000 wealth indicator merging [message #8409 is a reply to message #4224] Sat, 24 October 2015 13:54 Go to previous message
Saima is currently offline  Saima
Messages: 10
Registered: October 2015
Location: Bowling Green, Ohio
Member
Thanks. I figured it out and did the same way which you recommended.

Saima
Previous Topic: Comparative Wealth Index for 2010 Burundi
Next Topic: Regional Dummy in the Wealth Index
Goto Forum:
  


Current Time: Fri Aug 12 10:12:54 Coordinated Universal Time 2022