| Ethiopia 2000 wealth indicator merging [message #4222] |
Mon, 20 April 2015 16:43  |
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  |
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?
|
|
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
