The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Constructing Wealth Incidence Curve (Confusion- Using Wealth Index to Construct Wealth Incidence Curve)
Constructing Wealth Incidence Curve [message #29351] Mon, 03 June 2024 15:21 Go to next message
tednoel is currently offline  tednoel
Messages: 12
Registered: April 2024
Member
Hi all, just creating a post here to see if anyone might be able to assist. I am trying to create wealth index curves for Senegal using DHS data spanning from the years of 2015 to 2021 but there is something that I am either conceptually misunderstanding or not doing right with the code. I've pasted my code below for people to examine:

svyset [pweight=hv005], strata(hv023) psu(hv001)
gen wealth_quintile_2015 = hv270 if hv007 == 2015
gen wealth_quintile_2017 = hv270 if hv007 == 2017

* Calculate mean wealth for each quintile in 2015
svy: mean hv270, over(wealth_quintile_2015)

* Calculate mean wealth for each quintile in 2017
svy: mean hv270, over(wealth_quintile_2017)

* Merge the datasets
merge 1:1 wealth_quintile_2015 using wealth_quintile_2017, keep(match)

* Calculate growth rates between the two years
gen growth_rate = (wealth_quintile_2017 - wealth_quintile_2015) / wealth_quintile_2015

* Plot the Growth Incidence Curve
twoway (line growth_rate, sort title("Wealth Incidence Curve") xlabel(1(1)5) ylabel(, angle(0))))

As you can see I tried to incorporate population weights so that these wealth incidence curves could be representative at the household level... But nothing is working. When I am actually able to produce an incidence curve the curve is blank. I'm starting to think perhaps it's a problem with the variable itself? I didn't think there would be much issue using a wealth index because it would still capture levels of wealth which would be aggregated into the wealth incidence curve. Any advice here would be really appreciated. If wealth index is not suitable for creating a wealth incidence curve, is there a way to collapse the wealth index into a measurement of overall wealth? Thank you so much in advance!!!
Re: Constructing Wealth Incidence Curve [message #29353 is a reply to message #29351] Tue, 04 June 2024 08:42 Go to previous messageGo to next message
tednoel is currently offline  tednoel
Messages: 12
Registered: April 2024
Member
Ok I now understand my original error. I had believed that there were numeric values associated with the "poorest" "poor" etc, categories for the wealth index. At this point I have shifted the strategy to creating wealth indices that demonstrate the change in proportion of those who are categorized as "poorest" from 2015-2021 for Senegal. I can generate the graph but there are no indices and I suspect this is an issue of scale. I know I need to incorporate survey weights in the code but I'm not sure where to do this.

*** Disaggregate Wealth Quintiles by Year
svyset [pweight=hv005], strata(hv023) psu(hv001)
gen wealth_quintile_2015 = hv270 if hv007 == 2015
gen wealth_quintile_2017 = hv270 if hv007 == 2017
gen wealth_quintile_2018 = hv270 if hv007 == 2018
gen wealth_quintile_2019 = hv270 if hv007 == 2019
gen wealth_quintile_2020 = hv270 if hv007 == 2020
gen wealth_quintile_2021 = hv270 if hv007 == 2021

****** MY FIRST ATTEMPT
*Calculate the proportion of individuals classified as "poorest" within the variable for each year
egen poverty2015 = group(wealth_quintile_2015)
egen prop_poorest_2015 = mean(wealth_quintile_2015 == 1), by(poverty2015)

egen poverty2017 = group(wealth_quintile_2017)
egen prop_poorest_2017 = mean(wealth_quintile_2017 == 1), by(poverty2017)

egen poverty2018 = group(wealth_quintile_2018)
egen prop_poorest_2018 = mean(wealth_quintile_2018 == 1), by(poverty2018)

egen poverty2019 = group(wealth_quintile_2019)
egen prop_poorest_2019 = mean(wealth_quintile_2015 == 1), by(poverty2015)

egen poverty2020 = group(wealth_quintile_2020)
egen prop_poorest_2020 = mean(wealth_quintile_2020 == 1), by(poverty2020)

egen poverty2021 = group(wealth_quintile_2021)
egen prop_poorest_2021 = mean(wealth_quintile_2021 == 1), by(poverty2021)

*** This did not work so below is my second attempt
*******

* Calculate the proportion of individuals classified as "poorest" for each year separately
egen prop_poorest_2015_2 = mean(wealth_quintile_2015 == 1 & wealth_quintile_2015)
egen prop_poorest_2017_1 = mean(wealth_quintile_2017 == 1 & wealth_quintile_2017)
egen prop_poorest_2018_1 = mean(wealth_quintile_2018 == 1 & wealth_quintile_2018)
egen prop_poorest_2019_1 = mean(wealth_quintile_2019 == 1 & wealth_quintile_2019)
egen prop_poorest_2020_1 = mean(wealth_quintile_2020 == 1 & wealth_quintile_2020)
egen prop_poorest_2021_1 = mean(wealth_quintile_2021 == 1 & wealth_quintile_2021)


twoway (line prop_poorest_2015_1 prop_poorest_2017_1 prop_poorest_2018_1 prop_poorest_2019_1 prop_poorest_2020_1 prop_poorest_2021_1, ytitle(Proportion "Poorest") xtitle(Years) legend(off))

Neither one of these attempts produces a viable graph and I think I need to incorporate the sampling weights
Re: Constructing Wealth Incidence Curve [message #29402 is a reply to message #29353] Tue, 11 June 2024 16:01 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 737
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

I don't understand what you are trying to do. hv270 is a household-level variable, constructed in such a way that 1/5 of the de jure cases in the PR file are in each of the 5 quintiles. It is a measure of relative wealth in each survey, or each round of the Senegal Continuous Survey. It is not a measure of absolute wealth--or poverty. Thus there is no difference or change from one survey to another in the proportion of cases in the poorest category.

What do you mean by "wealth index curves" in your initial post? What kind of a "viable graph" are you looking for? You can use the continuous wealth index (hv271) to calculate a Gini coefficient to measure inequality. Is that what you are looking for? Or something else? Please say, in words, what you are trying to show with your figure, and then I'd be happy to try to help.
Previous Topic: Wealth indices compare to income and consumption measures
Goto Forum:
  


Current Time: Sun Jun 16 14:19:34 Coordinated Universal Time 2024