The DHS Program User Forum: Wealth Index » How to arrive at final wealth index score using PCA

Home » Topics » Wealth Index » How to arrive at final wealth index score using PCA

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

Re: How to arrive at final wealth index score using PCA [message #28714 is a reply to message #28666]

Wed, 28 February 2024 14:01

Janet-DHS
Messages: 938
Registered: April 2022

Senior Member

Following is a response from DHS staff member, Tom Pullum:

Yes, you can match the SPSS procedure with Stata. Have you looked at the DHS website (https://www.dhsprogram.com/topics/wealth-index/index.cfm)? MANY variables go into that PCA. Various people have tried to simplify the construction, and I support that, but if you simplify it you will not get a match.

The conversion to quintiles is a little more complex. The following lines, applied the HR file, show how to do it ("mem" is the number of household members). You have to do it with the HR file because everyone in the same household has the same value of the continuous index and is in the same quintile.

set more off

use "...NGHR7AFL.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_test1=hv271 [pweight=pwt], nquantiles(5)

tab hv270 hv270_test1 [iweight=wt]

Report message to a moderator

[Message index]

		How to arrive at final wealth index score using PCA By: annabellebronson on Mon, 19 February 2024 05:10
		Re: How to arrive at final wealth index score using PCA By: Janet-DHS on Wed, 28 February 2024 14:01
		Re: How to arrive at final wealth index score using PCA By: on Wed, 30 October 2024 21:27
		Re: How to arrive at final wealth index score using PCA By: tahirandreas5 on Thu, 31 October 2024 17:22
		Re: How to arrive at final wealth index score using PCA By: on Mon, 24 February 2025 21:11
		Re: How to arrive at final wealth index score using PCA By: Anonymous on Tue, 18 March 2025 00:14
		Re: How to arrive at final wealth index score using PCA By: on Sat, 23 August 2025 10:18
		Re: How to arrive at final wealth index score using PCA By: emmascott637 on Mon, 25 August 2025 04:59

Previous Topic:

Type of house

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Sep 5 16:45:10 Coordinated Universal Time 2025