The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Comparative Wealth Index for Bangladesh
Comparative Wealth Index for Bangladesh [message #8152] Sat, 29 August 2015 12:48 Go to next message
suzzon is currently offline  suzzon
Messages: 18
Registered: July 2013
Location: Bangladesh
Member
Dear DHS experts,

I would like to calculate comparative wealth index of Bangladesh for all the six standard DHS surveys namely, BDHS 1993-94, 1996-97, 1999-00, 2004, 2007, and 2011. Is it possible to share the STATA or SPSS syntax for constructing Comparative Wealth Index (i.e. Constant (Alpha) and Coefficient (Beta))?

If it is not possible to share the code, can you share the Constant (Alpha) and Coefficient (Beta) of the CWI equation for the respective surveys?

Thank you.

Moin

Re: Comparative Wealth Index for Bangladesh [message #8175 is a reply to message #8152] Wed, 02 September 2015 15:59 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
We don't have any code to share at this time, but we hope the attached file will be of some help.
Re: Comparative Wealth Index for Bangladesh [message #8177 is a reply to message #8175] Thu, 03 September 2015 11:57 Go to previous messageGo to next message
suzzon is currently offline  suzzon
Messages: 18
Registered: July 2013
Location: Bangladesh
Member
Thank you Liz-DHS.
Re: Comparative Wealth Index for Bangladesh [message #9131 is a reply to message #8177] Sun, 14 February 2016 17:36 Go to previous messageGo to next message
mmr-UMICH is currently offline  mmr-UMICH
Messages: 21
Registered: February 2015
Location: A2, MI
Member
Hi Experts,

I have question about syntax code given in your Wealth Index computation page and thanks you for sharing syntax codes.

I wanted to calculate the wealth index for Rural Bangladesh for DHS 2011 data, so downloaded a SPSS syntax from Wealth Index computation page:
(file name: bangladesh 2011 sps.pdf) from: http://www.dhsprogram.com/programming/wealth%20index/Banglad esh%20DHS%202011/bangladesh%202011%20sps.pdf

It seems to me many of the variables used in this program code are QH series variables, but Bangladesh Household recode data set has variables series with HV naming.
As for example, qh102 is "drinking water supply" in the wealth index calculation syntax, but hv201 is "supply of drinking water" is in 2011 Bangladesh Household recode spss syntax and data set. I also saw that there are differences in naming of corresponding variable names between two program codes. Could you please verify the matter and if possible to replace the above program with the right one in Wealth Index calculation page?

Thanking you in advance.
Re: Comparative Wealth Index for Bangladesh [message #9142 is a reply to message #9131] Mon, 15 February 2016 13:52 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
A response from Dr. Shea Rutstein:
Quote:

Wealth index syntax files with qh variables are based on the raw data files. Those with HV variables are based on the recode data files. Since the recode files are not the same as the raw data files, one cannot just rename the variables even though some are not much different. If the variables begin with qh, the raw data file should be used. Once the wealth index score and quintile variables are produced, they can be merged with the standard recode files. The values of the variables is the same for the household data and for the individual data files.

Thank you!
Re: Comparative Wealth Index for Bangladesh [message #9144 is a reply to message #9142] Mon, 15 February 2016 15:56 Go to previous messageGo to next message
mmr-UMICH is currently offline  mmr-UMICH
Messages: 21
Registered: February 2015
Location: A2, MI
Member
Thank you so much, Dr. Rutstein.

Hi Liz:

For Bangladesh DHS 2011, there is no Household Raw data file (which should have qh series variables as Dr. Rutstein mentioned in his reply). Could you please let me know from where I can download Household Raw data file. Thanking you.

Moshiur
Re: Comparative Wealth Index for Bangladesh [message #9145 is a reply to message #8152] Mon, 15 February 2016 17:45 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
We do not distribute the raw data files, but rather the recode datasets. While the wealth index calculations are based on the raw data files, you should be able to translate the wealth index logic to refer to recode variables fairly easily as they are essentially a one to one correspondence.
Re: Comparative Wealth Index for Bangladesh [message #9193 is a reply to message #9145] Sun, 21 February 2016 00:44 Go to previous messageGo to next message
mmr-UMICH is currently offline  mmr-UMICH
Messages: 21
Registered: February 2015
Location: A2, MI
Member
Thank you so much, Dr. Trevor.

I have a related question for my previous request. You know I wanted to calculate the rural wealth index for Bangladesh DHS 2011, as I mentioned previous email that I downloaded an SPSS syntax file from DHS website which QH series variables using DHS raw data. I am trying to prepare the code as per your advice; trying to find the corresponding variables of QH series from HV variables in recode data set. I did almost major part of the syntax but I cannot figure out corresponding HV variables for the following variables (I cut and paste from the downloaded syntax code). Could you please provide me the variable labels of these variables at your earliest possible convenience. Thanking you again.

(I collect the variables here: qh110A to qh110L qh118A to qh118D qh121 qh122a to qh122c
qh122_1 to qh122_5 qh123 and DOMESTIC)

*{Reset missing values to "does not have", change 2 code to 0}.
if (missing(qh110a) | qh110a<>1) qh110a=0.
if (missing(qh110b) | qh110b<>1) qh110b=0.
if (missing(qh110c) | qh110c<>1) qh110c=0.
if (missing(qh110d) | qh110d<>1) qh110d=0.
if (missing(qh110e) | qh110e<>1) qh110e=0.
if (missing(qh110f) | qh110f<>1) qh110f=0.
if (missing(qh110g) | qh110g<>1) qh110g=0.
if (missing(qh110h) | qh110h<>1) qh110h=0.
if (missing(qh110i) | qh110i<>1) qh110i=0.
if (missing(qh110j) | qh110j<>1) qh110j=0.
if (missing(qh110k) | qh110k<>1) qh110k=0.
if (missing(qh110l) | qh110l<>1) qh110l=0.
if (missing(qh118a) | qh118a<>1) qh118a=0.
if (missing(qh118b) | qh118b<>1) qh118b=0.
if (missing(qh118c) | qh118c<>1) qh118c=0.
if (missing(qh118d) | qh118d<>1) qh118d=0.
if (not(missing(qh122c)) & qh122c < 99.98) landarea=qh122c.
if (qh122c=99.95) landarea=95.
if (missing(qh122b) | qh122b<>1) landarea=0.
frequencies landarea.
if (missing(qh121) | qh121 <>1) qh121=0.
if (missing(qh122_1) | qh121 <>1) qh122_1=0.
if (missing(qh122_2) | qh121 <>1) qh122_2=0.
*if (missing(qh122_3) | qh121 <>1) qh122_3=0.
if (missing(qh122_4) | qh121 <>1) qh122_4=0.
if (missing(qh122_5) | qh121 <>1) qh122_5=0.
if (missing(qh122a) | qh122a<>1) qh122a=0.
missing values qh122_1 to qh122_5 (98,99).
if (missing(qh123) | qh123<>1) qh123=0.

Rahman
Re: Comparative Wealth Index for Bangladesh [message #9239 is a reply to message #9193] Thu, 25 February 2016 23:12 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 787
Registered: January 2013
Senior Member
Below I'm providing the related variables:
    HV206  = YesNo( QH110A ); { electricity }
    HV207  = YesNo( QH110B ); { radio }
    HV208  = YesNo( QH110C ); { television }
    HV243A = YesNo( QH110D ); {mobile phone }
    HV221  = YesNo( QH110E );
    HV209  = YesNo( QH110F ); { refrigerator }
    SH110G = YesNo( QH110G ); {Almirah/wardrc}
    SH110H = YesNo( QH110H ); {Table}
    SH110I = YesNo( QH110I ); {Chair}
    SH110J = YesNo( QH110J ); {Electric fan}
    SH110K = YesNo( QH110K ); {DVD/VCD player}
    SH110L = YesNo( QH110L ); {Water pump}
    SH118A = YesNo( QH118A ); {Autobike}
    SH118B = YesNo( QH118B ); {Rickshaw}
    HV210  = YesNo( QH118C ); { bicycle }
    HV211  = YesNo( QH118D ); { motorcycle/scooter }
    HV246  = YesNo( QH121 );
    HV246G = NAToZero( QH122_1 ); { CS  Bulls/Buffaloes}
    HV246B = NAToZero( QH122_2 ); { cows, bulls }
*   QH122_3 doesn't exist.    
    HV246H = NAToZero( QH122_4 ); { CS  Goat/Sheep     }
    HV246I = NAToZero( QH122_5 ); { CS  Chickens/Ducks }
    SH122A = YesNo(QH122A);   {owns homestead}
    SH122C = NAtozero(QH122C);      {!! amount of land}
    HV247  = YesNo( QH123 );

Yesno() is a function we use in CSPro to convert code 2 for No to code 0 in the recode.
NAtoZero() is a function used to convert not applicable (missing in Stata parlance) values to 0 in the recode.
Re: Comparative Wealth Index for Bangladesh [message #9269 is a reply to message #9239] Tue, 01 March 2016 14:21 Go to previous message
mmr-UMICH is currently offline  mmr-UMICH
Messages: 21
Registered: February 2015
Location: A2, MI
Member
Thank you so much Dr. Trevor.
Previous Topic: Comparative Wealth Index for 5 countries: Need alpha and betas
Next Topic: Ghana DHS 2014 factor weight file - possible error?
Goto Forum:
  


Current Time: Thu Mar 28 10:25:25 Coordinated Universal Time 2024