The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Countries » Uganda » identifying districts
identifying districts [message #1267] Wed, 29 January 2014 15:22 Go to next message
shivelyg is currently offline  shivelyg
Messages: 1
Registered: January 2014
Location: Purdue University
Member
I am having difficulty identifying the district, county and sub-county for observations in the 2011 Uganda DHS dataset. For the 2006 DHS these variables were named shdist, shcounty and shscty. These variables do not appear on the 2011 UGHR60FL.DTA dataset. Does anyone know how to identify this information?
Re: identifying districts [message #1268 is a reply to message #1267] Wed, 29 January 2014 17:22 Go to previous messageGo to next message
user-rhs is currently offline  user-rhs
Messages: 132
Registered: December 2013
Senior Member
The files called UGHR60FL.FRQ, UGHR60FL.FRW, and UGHR60FL.MAP give descriptions/tabulations of all variables in the UGHR60FL dataset. You can open these in Notepad/textedit, and do a search (CTRL F) for district, county, etc. If the vbl is in the released dataset, you should be able to see what the name is in the dataset. Check also the Individual Recode file if you can't find it in the HH recode dataset. Remember that Stata is case-sensitive


HTH,

rhs
Re: identifying districts [message #11681 is a reply to message #1268] Fri, 27 January 2017 06:34 Go to previous messageGo to next message
Penny is currently offline  Penny
Messages: 2
Registered: November 2015
Location: Uganda
Member
Dear all,

This is to inquire if I can get the 2007 SPA data for Uganda with the district variable. The UGSR5S file shows that district variable was deleted, is it possible to get the data with district variable.

Thank you

Peninah
Re: identifying districts [message #11732 is a reply to message #11681] Fri, 03 February 2017 18:58 Go to previous messageGo to next message
Liz-DHS
Messages: 971
Registered: February 2013
Senior Member
Dear User,
A response from data processing expert, Claudia Marchena:
Quote:

In surveys before 2009 the consent for SPA surveys did not allow to share locations for facilities nor facility names. Providing this piece of information will potentially identify facilities since, for instance, there are few hospitals and if district location would have been provided, it could identify the hospital. This would violate the confidentiality terms set for SPA surveys before 2009.
Re: identifying districts [message #11838 is a reply to message #11732] Thu, 16 February 2017 10:15 Go to previous messageGo to next message
Penny is currently offline  Penny
Messages: 2
Registered: November 2015
Location: Uganda
Member
Hi Liz,

Thanks to Claudia for the response.

Now my question is on linking 2007 Uganda SPA data.
My unit of analysis is health facility so I have merged ANC data to Provider using facilty number and ProviderID. I have then tried to merge the new data file to facility data using facility number.
However, I get an error message "Duplicate key in a file. The BY variables do not uniquely identify each case on the indicated file. Please check the results carefully". I would like to know if there is something I did not do well and what that message means. Any other information on how I can merge the 3 datasets is welcome. I am using SPSS.

Thanks and Kind regards

Peninah

Re: identifying districts [message #12028 is a reply to message #11732] Tue, 21 March 2017 05:31 Go to previous messageGo to next message
CeciliaLH
Messages: 1
Registered: March 2017
Member
Dear Liz,

Will it be possible to know what districts are defined in the seven regions of the 2007 Uganda SPA data?
I am trying to merge the SPA data with non-DHS data, which is only identified on district level, hence I need to know what districts are within each region to match the identifying variables. Will that be within the confidentiality terms?

Thank you
Cecilia
Re: identifying districts [message #12139 is a reply to message #12028] Fri, 31 March 2017 15:07 Go to previous message
Liz-DHS
Messages: 971
Registered: February 2013
Senior Member
A response from data processing expert, Claudia Marchena:
Quote:

In surveys before 2009 the consent for SPA surveys did not allow to share locations for facilities nor facility names. Providing this piece of information will potentially identify facilities since, for instance, there are few hospitals and if district location would have been provided, it could identify the hospital. This would violate the confidentiality terms set for SPA surveys before 2009.
Previous Topic: 2011 stata data file
Next Topic: Sample strata in 2011DHS
Goto Forum:
  


Current Time: Sat May 27 15:14:29 Eastern Daylight Time 2017