The DHS Program User Forum: Wealth Index » Problem with recreating Asset quintiles

Home » Topics » Wealth Index » Problem with recreating Asset quintiles

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Problem with recreating Asset quintiles [message #24626 is a reply to message #24620]

Thu, 09 June 2022 08:36

Janet-DHS
Messages: 495
Registered: April 2022

Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

Here is the Stata code to construct wealth quintiles as "hv270_test", which you can compare with hv270. This can be applied to any HR file. (HR, not PR.) It should be easy enough to translate into R.

use "xxHRxxFL.DTA" , clear
keep hv001 hv002 hv005 hv012 hv013 hv270 hv271
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 [iweight=wt]

Report message to a moderator

[Message index]

		Problem with recreating Asset quintiles By: Preksha Mishra on Wed, 08 June 2022 14:33
		Re: Problem with recreating Asset quintiles By: Janet-DHS on Thu, 09 June 2022 08:36
		Re: Problem with recreating Asset quintiles By: Preksha Mishra on Fri, 10 June 2022 02:07
		Re: Problem with recreating Asset quintiles By: Preksha Mishra on Fri, 10 June 2022 02:30
		Re: Problem with recreating Asset quintiles By: Janet-DHS on Mon, 13 June 2022 11:11

Previous Topic:	sub-national wealth quintiles in STATcompiler
Next Topic:	Not positive definite correlation matrix

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Sep 23 09:59:50 Coordinated Universal Time 2023