Unspecified codes for water source and toilet type [message #2380] |
Wed, 11 June 2014 13:43 |
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 #2424 is a reply to message #2380] |
Tue, 17 June 2014 11:09 |
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 #2451 is a reply to message #2449] |
Thu, 19 June 2014 09:50 |
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!
|
|
|