The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » 2011 wealth class data on access to electricity in Benin Burundi Cote d'Ivoire Ethiopia and Cambodia (We found the abnormal datapoint in 2011 based on the classification of wealth class.)
2011 wealth class data on access to electricity in Benin Burundi Cote d'Ivoire Ethiopia and Cambodia [message #30075] Fri, 20 September 2024 01:43 Go to next message
Miramk is currently offline  Miramk
Messages: 1
Registered: September 2024
Member
Hello,

We are trying to investigate the trend of the proportion of the population with access to electricity in their household in the developing countries based on the classification of wealth class. We further classify the individual level data into 20 wealth classes based on the weight and wealth index, but found abnormal trend in 2011 in several countries, including Benin, Burundi, Cote d'Ivoire, Ethiopia and Cambodia.

We looked into the classes in Benin for instance, as shown in the following figure, the wealth class categories based on weight seems strange. I am wondering about the wealth index and categorization. Could you please check the data format? Thanks!
Re: 2011 wealth class data on access to electricity in Benin Burundi Cote d'Ivoire Ethiopia and Cambodia [message #30111 is a reply to message #30075] Tue, 24 September 2024 20:55 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 880
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:
I think there may be a problem with the way you are constructing the 20 wealth categories. I see that in Benin 2011, for example, the continuous wealth distribution (hv271) is very skewed, and that may be carrying over into your categorization.

Here are Stata lines that will approximately reproduce the standard quintiles (5 categories), illustrated with a Nigeria survey:
* SIMPLE STATA CODE TO CONSTRUCT WEALTH QUINTILES THAT ALMOST MATCH DHS

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]

I say "approximately" because DHS has a way of handling ties that is difficult to reproduce exactly.

To get 20 categories, use "nquantiles(20)". You will have to alter for packages other than Stata.

I use the HR file because units are households. However, the goal is to equalize the number of de jure household members who are in each category. The categories produced in the HR file can be copied into the PR file, etc.

I have not checked whether this will solve your issue. Let us know if it does not.
Previous Topic: WEIGHTS AFTER DROP OUTS
Next Topic: Inquire about variables
Goto Forum:
  


Current Time: Sat Nov 9 08:24:27 Coordinated Universal Time 2024