W&S data by income quantile and urban [message #12520] |
Mon, 05 June 2017 11:36 |
dhswes
Messages: 6 Registered: June 2017
|
Member |
|
|
Hello:
I am trying to disaggregate data by both urban population and income quantiles at the country-level. For example the % of the population with access to piped water on premises by urban income quintile. It does not seem that the Stat Compiler allows one to select these data? I guess I need to download the raw country files? Please advise.
Best,
Michael
|
|
|
Re: W&S data by income quantile and urban [message #14565 is a reply to message #12520] |
Sat, 21 April 2018 20:07 |
kingx025
Messages: 95 Registered: August 2016 Location: Minneapolis. Minnesota
|
Senior Member |
|
|
If you do decide to run the numbers yourself, you may find it easier to make a dataset for many countries using IPUMS-DHS (at idhsdata.org). You can log in with your DHS user email and password, and then select the variables and samples you need to create a customized dataset for your research question, in the format you prefer (e.g., Stata, SAS, SPSS, or CSV). IPUMS-DHS currently includes data for 28 countries and 117 samples.
Here are some of the variables you might choose to include, using "household members" as your unit of analysis:
HV025 (Urban-rural status)
HV201 (major source of drinking water) -- all responses beginning with a coded first digit of 1 for piped water
HV270 (Household wealth index in quintiles)
Variables you need to sort out which country and sample year is covered are automatically added to your data extract (customized data file).
While analyzing the data yourself is more work than downloading the summary statistics from Statcompiler, making a customized file for analysis through IPUMS-DHS will save you some time.
Miriam King
Dr. Miriam King
IPUMS-DHS Project Manager (www.idhsdata.org)
|
|
|