The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » General Data Questions » Small error in Philippines Raw Service Availability dataset
Small error in Philippines Raw Service Availability dataset [message #13148] Thu, 28 September 2017 14:51 Go to previous message
Craig is currently offline  Craig
Messages: 3
Registered: September 2017
Location: New York, NY
Member
I'm specifically looking at PHSQ30FL.SAS, within the PHSQ30FL.ZIP file.
This is an SAS program, designed to interpret the .DAT flat file. Within this program, it assigns the characters in bytes 61-65 of each record to field S107 ("Transport to go to urban centr"), and then tells the program to interpret those bytes using the data dictionary for format S107_.
The data dictionary for S107_ reads:
value S107_
1 = "A.Walking"
2 = "B.Personal vehicle"
3 = "C.Hired vehicle"
4 = "D.Public transport"
5 = "E.Other"
6 = "?.Missing"
;
That is, it can interpret values "1","2",...,"6" as individual characters appearing in the record and treats the question as multiple-answer. However, when you look at the actual records, you find values "A",...,"E","?" appearing.
That is, the data dictionary would be correct if it read
value S107_
"A" = "Walking"
"B" = "Personal vehicle"
"C" = "Hired vehicle"
"D" = "Public transport"
"E" = "Other"
"?" = "Missing"
;
but as it stands it does not parse the records correctly.

Just letting you know; it's a relatively easy fix.
 
Read Message
Read Message
Read Message
Previous Topic: Question on Recode Manual
Next Topic: Interviews Requiring Multiple Visits
Goto Forum:
  


Current Time: Sun Apr 28 06:15:34 Coordinated Universal Time 2024