The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Other countries » Pakistan DHS7 Public Transport (Pakistan DHS7 Public Transport availability and distance from village)
Pakistan DHS7 Public Transport [message #30251] Wed, 23 October 2024 01:37 Go to next message
HS
Messages: 4
Registered: September 2024
Member
This is regarding service provisions module in DHS7 for Pakistan.

For public transport, if the service (t203_03 & t203_04) is available in the village, the distance to the service (var names t204_03 and t204_04) is given as a missing value'.'
However, when the service is NOT available in that village(t203_03 ==2 or t203_04 ==2) the distance of village from the service is sometimes given zero and sometimes a missing value'.' How should we differentiate and interpret these cases?


Re: Pakistan DHS7 Public Transport [message #30279 is a reply to message #30251] Fri, 25 October 2024 14:42 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 885
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

You are asking about the data file PKSQ71, from the Pakistan 2017 service availability survey. I don't believe we have had any earlier questions about the file.

There a questions about a series of services identified with A, B, etc. and a series of facility types also identified with A, B, etc. You will have to go to the questionnaire to find out what the letters A, B, etc. stand for.

For each type of service it is asked "is this service available in this village?" If the answer is no, the distance is asked. If the answer is yes, then distance is Not Applicable, or NA. Actually it would be ok to recode the distance as 0 for such services.

For facility types, there is NOT a question "is this facility found in this village".

I will paste below some Stata lines to reshape the data and make it more useful. I recode those NA cases to have distance=0. Hope this will be helpful.

* Using the SQ file for the Pakistan 2017 service availability survey

 

use "...PKSQ71FL.DTA", clear

 

keep tcluster tregion tdistrict t*_*

rename *_0* *_*

 

reshape long t201n_ t203_ t204_ t301n_ t301_, i(tcluster tregion tdistrict) j(facility)

rename *_ *

drop if facility=.

 

label variable t201n "Type of service"

 

label variable t203 "Available in village?"

label define t203 1 "Yes" 2 "No"

label values t203 t203

label variable t204 "Distance to service"

 

label variable t301n "Type of facility"

label variable t301 "Distance to facility"

 

replace t204=0 if t203==1

tab t201n, summarize(t204) means obs

tab t301n, summarize(t301) means obs
Re: Pakistan DHS7 Public Transport [message #30285 is a reply to message #30279] Sat, 26 October 2024 08:33 Go to previous message
HS
Messages: 4
Registered: September 2024
Member
Thank you for your help
Previous Topic: syntax SPSS, DHS 2017 about duration of breastfeeding
Goto Forum:
  


Current Time: Thu Nov 21 04:53:22 Coordinated Universal Time 2024