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
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: 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 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 (
Read Message
Read Message
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: Fri Apr 19 04:37:10 Coordinated Universal Time 2024