The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Water and Sanitation » Unspecified codes for water source and toilet type
Unspecified codes for water source and toilet type [message #2380] Wed, 11 June 2014 13:43 Go to next message
Gillian is currently offline  Gillian
Messages: 11
Registered: June 2014
Location: New York
Member
Hello, I'm working with child files in West Africa. There are a number of codes that appear for variables V113 and V116 that are not specified in the final report (see attached document). Can you give guidance on how these should be treated? If it's a small number of observations, I can see they could be treated as missing, but in some cases, there are hundreds or even thousands of observations. For example, may I assume that the 8,502 observations coded 31 for V116 in NI6 are composting toilets, although that category is not in the questionnaire or final report? For the 4,156 observations in SN6 coded 26, do users assume that is meant to be 25 (traditional latrines according to the Senegal report)? There are related issues with water source, especially code "43". Thank you.
Re: Unspecified codes for water source and toilet type [message #2394 is a reply to message #2380] Thu, 12 June 2014 23:37 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
We are currently researching your post and will get back to you as soon as possible.
Thank you!
Re: Unspecified codes for water source and toilet type [message #2414 is a reply to message #2394] Sun, 15 June 2014 14:20 Go to previous messageGo to next message
jamimont is currently offline  jamimont
Messages: 3
Registered: June 2014
Location: United States
Member
I found the same issue working with the Ethiopia 2011 data for the household drinking water source code (HV201) - there multiple occurrences of "43" and "62" in the household file for this survey that also not specified in the final report.
Re: Unspecified codes for water source and toilet type [message #2422 is a reply to message #2380] Tue, 17 June 2014 09:51 Go to previous messageGo to next message
Gillian is currently offline  Gillian
Messages: 11
Registered: June 2014
Location: New York
Member
Please add to this question Nigeria 6A (2013).

Source of drinking water (V113):

Code Observations
43 5109
62 328
72 905

Type of toilet facility (V116):

Code Observations
42 27
43 829
Re: Unspecified codes for water source and toilet type [message #2424 is a reply to message #2380] Tue, 17 June 2014 11:09 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
I started looking at your spreadsheet and looked at Niger (NI6), I am assuming you are looking at Niger DHS 2012. In this case code 31 for V116 is "No facility/bush/field." Looking at the frequencies, V116 weighted is 7,766 and V116 unweighted is 6,812. Are we looking at the same data set? I am looking at the Niger DHS 2012 survey.
I found this information by looking at MAP file distributed with the data set. Where did you get your number of 8502?
The recode application for Niger DHS 2012 recoded as follows:
box QH107 => HV205;
11-19 => QH107; { flush toliet }
21-29 => QH107; { pit latrine }
41 => 42; { bucket }
61 => 31; { no facility/bush/field }
=> QH107;
endbox;

Later in the application:
V116 = HV205; { Type of toilet facility }

This should help.

Also not sure where you are getting "composting toilet"

Thank you!



Re: Unspecified codes for water source and toilet type [message #2428 is a reply to message #2424] Tue, 17 June 2014 13:21 Go to previous messageGo to next message
Gillian is currently offline  Gillian
Messages: 11
Registered: June 2014
Location: New York
Member
Oh I see now, thanks! I was using the codes from the questionnaire (final report and model) and didn't know about the MAP file. Slightly embarrassing, but hopefully this discussion will save others time and anxiety...
Re: Unspecified codes for water source and toilet type [message #2429 is a reply to message #2428] Tue, 17 June 2014 13:55 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Not a problem. As you mentioned, it may help others.
Thanks!
Re: Unspecified codes for water source and toilet type [message #2449 is a reply to message #2429] Thu, 19 June 2014 09:39 Go to previous messageGo to next message
jamimont is currently offline  jamimont
Messages: 3
Registered: June 2014
Location: United States
Member
Liz - What is the MAP file that you are referring to? I'm working with the Ethiopia 2011 DHS data set and had a similar issue with unspecified drinking water source codes for HV201 of 43 and 62. I didn't see a MAP file for this dataset but since I'm not sure what it is it is entirely possible I've overlooked it!

The code definitions you gave for the question of the Niger dataset seemed to fit more for toilet facility type and not a dw source
Re: Unspecified codes for water source and toilet type [message #2450 is a reply to message #2449] Thu, 19 June 2014 09:45 Go to previous messageGo to next message
jamimont is currently offline  jamimont
Messages: 3
Registered: June 2014
Location: United States
Member
Oops...disregard this query - I found the MAP file for the survey dataset and the answer for my question!
Re: Unspecified codes for water source and toilet type [message #2451 is a reply to message #2449] Thu, 19 June 2014 09:50 Go to previous message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
In the zip file(s) you downloaded, there should have been a file with an extension .MAP. It comes along with the data file,dictionary file, documentation file, frequency files (both weighted and unweighted).

For example, ETIR61.ZIP (Ethiopia hierarchical data set used with CSPro)contains:

ETIR61.DAT data file
ETIR61.DCF dictionary file
ETIR61.DOC documentation files (gives list of all country specific variables and details about the data)
ETIR61.FRQ unweighted frequencies
ETIR61.FRW weighted frequencies
ETIR61.MAP the map file

Thanks!
Previous Topic: child feces disposal
Next Topic: country-specific description of water and sanitation infrastructure
Goto Forum:
  


Current Time: Thu Dec 5 23:33:56 Coordinated Universal Time 2024