The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Bangladesh » Wealth Index data disaggregation
Wealth Index data disaggregation [message #25906] Sun, 01 January 2023 13:09 Go to next message
Nahid is currently offline  Nahid
Messages: 8
Registered: November 2020
Would it be possible to disaggregate the wealth index (windex5) with the Rural-Urban once the rural wealth index (windex5r) and urban wealth index (windex5u) are unavailable?
Re: Wealth Index data disaggregation [message #25920 is a reply to message #25906] Tue, 03 January 2023 20:31 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3113
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:

All the wealth quintiles are constructed with the HR file and the continuous index, hv271. The urban and rural versions are just constructed separately for the urban households and the rural households. The following code will match DHS exactly, except for perhaps a couple of households that are involved in ties when the continuous values are sorted.

Note that you have to copy the constructed values (in the HR file) to the PR and other files, with merges using just the cluster and household codes (and region for an India survey). Everyone (woman, man, and child) in the same household has the same value of the continuous wealth index and the quintiles.

The program is set up for a survey that already includes the urban and rural quintiles, so that you can check the calculation. You would have to change the program slightly for a survey that actually does NOT include the urban and rural quintiles.


set more off
use "...\HTHR71FL.DTA" , clear

keep hv001 hv002 hv005 hv012 hv013 hv025 hv270* hv271*

* calculate overall quintiles
gen mem = hv012
replace mem = hv013 if mem == 0
gen pwt=mem*hv005
gen wt=pwt/1000000
xtile hv270_test=hv271 [pweight=pwt], nquantiles(5)
tab hv270 hv270_test

* calculate urban quintiles
xtile hv270_test1=hv271 if hv025==1 [pweight=pwt], nquantiles(5)
tab hv270a hv270_test1 if hv025==1

* calculate rural quintiles
xtile hv270_test2=hv271 if hv025==2 [pweight=pwt], nquantiles(5)
tab hv270a hv270_test2 if hv025==2

gen hv270a_test=.
replace hv270a_test=hv270_test1 if hv025==1
replace hv270a_test=hv270_test2 if hv025==2

correlate hv270a hv270a_test
Previous Topic: Membership in NGO
Next Topic: [BD 1999-00 & 2004] Calculating HAZ and the other anthropometric measurements
Goto Forum:

Current Time: Sun Jul 14 09:50:11 Coordinated Universal Time 2024