The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Construction of wealth quintiles
Re: Construction of wealth quintiles [message #25982 is a reply to message #25981] Thu, 19 January 2023 08:30 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:

Here is the Stata code to construct the wealth quintiles, using the HR file:

gen mem = hv012
replace mem = hv013 if mem == 0
gen pwt=mem*hv005
gen wt=pwt/1000000
xtile hv270_test1=hv271 [pweight=pwt], nquantiles(5)
tab hv270 hv270_test1 [iweight=wt],m


/index.php?t=getfile&id=2004&private=0

/index.php?t=getfile&id=2005&private=0

There are just 5 such cases. They are right on the boundaries between two quintiles and I have no idea why the Stata code doesn't give hv270 exactly for them. But so far as your forum question goes, please check your lines against what I gave above. There may be a typo somewhere in your code.
  • Attachment: table.jpg
    (Size: 89.29KB, Downloaded 987 times)
  • Attachment: list.jpg
    (Size: 90.25KB, Downloaded 1038 times)
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Which wealth index to use for state specific studies
Next Topic: Comparative Wealth Index
Goto Forum:
  


Current Time: Tue Nov 26 16:32:09 Coordinated Universal Time 2024