The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Topics » Water and Sanitation » W&S data by income quantile and urban
W&S data by income quantile and urban [message #12520] Mon, 05 June 2017 11:36 Go to next message
dhswes is currently offline  dhswes
Messages: 6
Registered: June 2017

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.



Re: W&S data by income quantile and urban [message #14565 is a reply to message #12520] Sat, 21 April 2018 20:07 Go to previous message
kingx025 is currently offline  kingx025
Messages: 65
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 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 (
Previous Topic: Data on "receiving information about safe handling of water"
Next Topic: Existing water and sanitation infrastructure's impact on diarrhea incidents
Goto Forum:

Current Time: Wed Apr 25 16:09:07 Eastern Daylight Time 2018