The DHS Program User Forum: Wealth Index » Comparative Wealth Index for Bangladesh

Home » Topics » Wealth Index » Comparative Wealth Index for Bangladesh

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

Comparative Wealth Index for Bangladesh [message #8152]

Sat, 29 August 2015 12:48

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

Report message to a moderator

Re: Comparative Wealth Index for Bangladesh [message #8175 is a reply to message #8152]

Wed, 02 September 2015 15:59

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.

Attachment: Bangladesh_CWI_coefficients.xlsx
(Size: 9.00KB, Downloaded 581 times)

Report message to a moderator

Re: Comparative Wealth Index for Bangladesh [message #8177 is a reply to message #8175]

Thu, 03 September 2015 11:57

suzzon
Messages: 18
Registered: July 2013
Location: Bangladesh

Member

Thank you Liz-DHS.

Report message to a moderator

Re: Comparative Wealth Index for Bangladesh [message #9131 is a reply to message #8177]

Sun, 14 February 2016 17:36

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.

Report message to a moderator

Re: Comparative Wealth Index for Bangladesh [message #9142 is a reply to message #9131]

Mon, 15 February 2016 13:52

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!

Report message to a moderator

Re: Comparative Wealth Index for Bangladesh [message #9144 is a reply to message #9142]

Mon, 15 February 2016 15:56

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

Report message to a moderator

Re: Comparative Wealth Index for Bangladesh [message #9145 is a reply to message #8152]

Mon, 15 February 2016 17:45

Trevor-DHS
Messages: 802
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.

Report message to a moderator

Re: Comparative Wealth Index for Bangladesh [message #9193 is a reply to message #9145]

Sun, 21 February 2016 00:44

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

Report message to a moderator

Re: Comparative Wealth Index for Bangladesh [message #9239 is a reply to message #9193]

Thu, 25 February 2016 23:12

Trevor-DHS
Messages: 802
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.

Report message to a moderator

Re: Comparative Wealth Index for Bangladesh [message #9269 is a reply to message #9239]

Tue, 01 March 2016 14:21

mmr-UMICH
Messages: 21
Registered: February 2015
Location: A2, MI

Member

Thank you so much Dr. Trevor.

Report message to a moderator

Previous Topic:	Comparative Wealth Index for 5 countries: Need alpha and betas
Next Topic:	Ghana DHS 2014 factor weight file - possible error?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Oct 12 15:14:54 Coordinated Universal Time 2024