The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Recalculating and comparing Wealth Index for Côte d'Ivoire
Recalculating and comparing Wealth Index for Côte d'Ivoire [message #8960] Tue, 19 January 2016 13:59 Go to next message
baremma2002 is currently offline  baremma2002
Messages: 20
Registered: April 2013
Member
Dear DHS experts,

I'm using 1994, 1998-99 and 2011-12 Côte d'Ivoire DHS data and I'd like to calculate comparative wealth index (CWI) of Côte d'Ivoire for all those three standard DHS surveys in the trends analysis. I've three questions and I think these have not been asked yet for Côte d'Ivoire DHS data :

First, what are the values of the constant (alpha) and the coefficient (beta) that I can use to calculate the CWI for Côte d'Ivoire?

Second, the wealth index for 1994, 1998-99 and 2011-12 Côte d'Ivoire DHS data have been calculated and stored in seperate files. What are the variables used to compute the wealth index for each DHS and what were the techniques used (Principal Component Analysis, Principal Component Regression) for 1994 and 1998-99 DHS? Where can I find such files?

Third, do I have to get the same mean and the same standard deviation for CIW as found in this DHS report which is available at:

http://dhsprogram.com/publications/publication-MR9-Methodolo gical-Reports.cfm

Any help would be appreciated.

Thank you very much.
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #8995 is a reply to message #8960] Mon, 25 January 2016 13:05 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
Please take a look at this link on our website: http:// dhsprogram.com/topics/wealth-index/Wealth-Index-Construction .cfm
If you still have questions after reviewing the information, please feel free to post again.
Thank you!
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #9030 is a reply to message #8995] Thu, 28 January 2016 18:36 Go to previous messageGo to next message
baremma2002 is currently offline  baremma2002
Messages: 20
Registered: April 2013
Member
Thank you, Liz.

The big matter that I have is to build a code that will give me the constant (Alpha) and the coefficient (Beta) for 1994, 1998-99 and 2011-12 Côte d'Ivoire DHS respectively in order reconstruct the comparative wealth index (CWI) for each year.

Any help?

Thanks.
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #9031 is a reply to message #9030] Thu, 28 January 2016 18:43 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
Does the attached file help?
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #9047 is a reply to message #9031] Tue, 02 February 2016 04:15 Go to previous messageGo to next message
baremma2002 is currently offline  baremma2002
Messages: 20
Registered: April 2013
Member
Thank you very much.

This is the file I was looking for.
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #19806 is a reply to message #8995] Mon, 17 August 2020 06:21 Go to previous messageGo to next message
cdricmbella is currently offline  cdricmbella
Messages: 3
Registered: August 2020
Member
Dear liz I want to use the wealth index variable in the IR file of the cote d'ivoire 1998-1999 DHS. but it is not available in the dataset.

Please how can I manage it.


Thnak you for help



Cedric
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #19807 is a reply to message #19806] Mon, 17 August 2020 07:55 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member
Wealth Index analysis was introduced to DHS by the end of the 90's. When the decision to include the wealth index as part of DHS was made, standard variables were introduced to the recode definition for both the household and individual questionnaires (HV270 and HV271 for households; V190 and V191 for women; and MV190 and MV191 for men). For previous surveys a file containing the score and the quintile variables, was created. Essentially wealth index files were created for all DHS surveys except surveys carried out as part of the first DHS phase. The wealth index datasets can be found on the dataset page, once you are logged into your account. Please look for file names starting with: "CIWI".
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #19810 is a reply to message #19807] Mon, 17 August 2020 08:51 Go to previous messageGo to next message
cdricmbella is currently offline  cdricmbella
Messages: 3
Registered: August 2020
Member
Dear Bridget,

Thank you for your quick reply whixh is helpful.

Now my problem is how in Stata can I merge the IR file and the CIWI so that every woman belong to her wealth index household.

In the CIWI dataset I have 2122 observations while in the IR dataset I have 3040 observations. in the CIWI I have a household id variable which doesnt correspond to the case id variable (caseid) or household number variable (v002) in the IR dataset.

If I want to merge the two dataset in stata, please how can I proceed?

Thank you for your hepl.


Cedric
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #19853 is a reply to message #19810] Thu, 20 August 2020 13:51 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

Which CI survey are you using? There are two that have WI files. I see that both of those WI files have whhid as the household id. To do this merge you have to use the substring command ("substr") in Stata. Please try to use it but if you have trouble let us know, and tell us which CI survey you are using.
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #19864 is a reply to message #19853] Sun, 23 August 2020 00:26 Go to previous messageGo to next message
cdricmbella is currently offline  cdricmbella
Messages: 3
Registered: August 2020
Member
Thank you for your help.

I didnt succeed to merege the 2 datasets (CIWI & IR) correctly in stata. I use 1998-99 CI DHS dataset.


Please can you help me with the exact command in Stat that I can apply to merge the 2 datasets.

Looking forward to your reply


Thanks in advance


Regards
Re: Recalculating and comparing Wealth Index for Côte d'Ivoire [message #19878 is a reply to message #19864] Mon, 24 August 2020 17:07 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

The Stata lines listed below will do this. You should just need to change the paths. I have included some comments. The trickiest part is that you must extract v001 and v002 (or hv001 and hv002), which are numeric, from whhid, which is a string. This involves the substring and destring commands. The program shows how to do this. Let us know if you still have problems. Good luck!

set more off
use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\CIWI3AFL.DTA" , clear
rename wlthindf v191
rename wlthind5 v190

list whhid if _n<=20, table clean
describe whhid

* hhid is a 12-column string that includes v001 and v002
* need to break them out; to do that we need to find which column is which

local li=1
while `li'<=12 {
gen col_`li'=substr(whhid,`li',1)
local li=`li'+1
}

list whhid col_* if _n<=20, table clean

* apparently v001 is columns 8-10 and v002 is columns 11-12
drop col_*
gen v001=substr(whhid,1,10)
gen v002=substr(whhid,11,2)
destring v*, replace
sort v001 v002

* must save this file somewhere
save e:\DHS\DHS_data\scratch\CIWItemp.dta, replace

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\CIIR3AFL.DTA" , clear
* check the number of women in this file for later comparison
codebook v000
* there are 3040 women

sort v001 v002

* I prefer the "old" version of merge but this is a many:1 merge because there can be more
*   than one woman per household

merge v001 v002 using e:\DHS\DHS_data\scratch\CIWItemp.dta
tab _merge

* _merge=2 for 524 households that have no members in the IR file; drop them
* There are 3040 women with _merge=3, same as the number in the IR file

drop if _merge==2
drop _merge
save e:\DHS\DHS_data\scratch\CI3AFL_with_WI.dta, replace
tab v190

* I have checked and this file is ok, but I am surprised that the distribution of
*   women across wealth quintiles is so uneven.
Previous Topic: Comparative Wealth Index
Next Topic: Burkina Faso 2018 MIS WI creation
Goto Forum:
  


Current Time: Thu Mar 28 05:21:36 Coordinated Universal Time 2024