The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Wealth Quintiles for Malawi DHS 2000
Re: Wealth Quintiles for Malawi DHS 2000 [message #30724 is a reply to message #30711] Mon, 27 January 2025 12:44 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 938
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:
For the Malawi 2000 survey, the wealth index is "wlthind5" in a separate file called MWWI42FL.dta.  You should be able to access that file from the same place where you got the IR file. You can merge it with the IR file using the following lines:
use "...MWWI42FL.dta"
gen v001=substr(whhid,1,10)
gen v002=substr(whhid,11,2)
destring v001 v002, replace
drop whhid
rename wlthindf v191
rename wlthind5 v190

merge 1:m v001 v002 using "...MWIR41FL.dta"
keep if _merge==3
drop _merge
 
Read Message
Read Message
Previous Topic: Lesotho Data sets
Next Topic: Any Anaemia Ghana DHS 2022
Goto Forum:
  


Current Time: Thu Jul 17 01:16:29 Coordinated Universal Time 2025