| Issues with recalculating wealth index [message #22887] |
Fri, 28 May 2021 13:27  |
cw21
Messages: 4
Registered: May 2021
|
Member |
|
|
I am currently trying to reconstruct the wealth index for multiple countries (see excel attachment for specific countries) removing the cooking fuel variables, following the steps to constructing the new DHS Wealth Index ( https://dhsprogram.com/programming/wealth%20index/Steps_to_c onstructing_the_new_DHS_Wealth_Index.pdf). However, before start removing the cooking fuel variable I am make sure that I get the same results, as provided by DHS ( https://dhsprogram.com/topics/wealth-index/Wealth-Index-Cons truction.cfm). I have so far been through all the DHS countries with available SPSS code but have been unsuccessful in recreating the wealth index.
Please see the attachment for specific issues with each survey, however in brief I have the following issues:
1. The domestic, house and land variables do not match the descriptive statistics provided. I have detail how I have created these based on the guidance. Please could you advice if this is correct and why I may be getting different results?
a. Domestic has been calculated from V717=6 "Household and domestic" (or 7 "services" if 6 is not available) and the participant is unrelated to household head (v150=12). This is repeated for the man's questionnaire if available.
b. House: The only question regarding house ownership in most of the countries is in the individual recode is v745a "Owns a house alone or jointly" with house ownership being defined as v745a=1 or 2 or 3. Again this is repeated for the Man's questionnaire.
c. Land: The only question regarding working own land in most of the countries is in the individual recode is v745b "Owns land alone or jointly" with house ownership being defined as v745b=1 or 2 or 3. Again this is repeated for the Man's questionnaire.
2. Some of the provided results are different to the ones I am getting (see attachments), with disparities between included variables listed in the SPSS code and those on the excel document. In addition, some of the results and number of observations are different to those in the excel spread sheet. Can you please advise why I may be getting these difference and how to solve these issues? (I happy to provide more details if needed)
3. Finally, some of the SPPS code files on the website are corrupted and cannot be read.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
