The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Biomarkers » Merging ethiopia 2000 wealth indicators
Merging ethiopia 2000 wealth indicators [message #4221] Mon, 20 April 2015 16:36 Go to next message
annfitz is currently offline  annfitz
Messages: 5
Registered: April 2015

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: Merging ethiopia 2000 wealth indicators [message #4246 is a reply to message #4221] Fri, 24 April 2015 20:16 Go to previous messageGo to next message
user-rhs is currently offline  user-rhs
Messages: 132
Registered: December 2013
Senior Member
If you post your log from the merge (with error message), that would be helpful for us Stata users in debugging your commands

Re: Merging ethiopia 2000 wealth indicators [message #14555 is a reply to message #4221] Sat, 21 April 2018 17:24 Go to previous message
kingx025 is currently offline  kingx025
Messages: 95
Registered: August 2016
Location: Minneapolis. Minnesota
Senior Member
For samples included in IPUMS-DHS (available at, much of the merging between files has already been done for researchers. When the wealth index data or the child biometric data are in separate files in the original DHS data, we have done the merging already. Siminlarly, we have merged the household data to the women's recode files, and we have merged the household and mother's files to the files for children (KR files) and births (BR files). All of the standard DHS surveys for Ethiopia are in IPUMS-DHS; you can find the wealth index variables under their original DHS names or the IPUMS-DHS names of WEALTHQ and WEALTHS.

Miriam King
IPUMS-DHS project manager

Dr. Miriam King
IPUMS-DHS Project Manager (
Previous Topic: Linking HIV Data
Next Topic: Anthropometric measurements
Goto Forum:

Current Time: Fri Sep 25 19:06:13 Eastern Daylight Time 2020