| Wealth Quintiles for Malawi DHS 2000 [message #30711] |
Thu, 23 January 2025 12:26  |
andrew49@stanford.edu
Messages: 4
Registered: February 2024
|
Member |
|
|
Hello,
I'm currently running a research project that requires the use of wealth quintiles over the years in Malawi, looking specifically at the women's questionnaire. I notice that for the 2004 survey onwards, wealth quintile is included in the data under "v190". However, I fail to locate the wealth quintile variable for the 2000 survey. I've looked for it under "v190" as well as "hv270".
Am I missing something? There is a page on wealth index construction for 2000, so I figure there is a wealth quintile variable in the dataset, but please let me know if there's not. If there isn't, how could I import it or implement it myself?
Thanks!
[Updated on: Thu, 23 January 2025 12:26] Report message to a moderator |
|
|
|
| Re: Wealth Quintiles for Malawi DHS 2000 [message #30724 is a reply to message #30711] |
Mon, 27 January 2025 12:44  |
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 |
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
