Beyound District Infon in DHS data 2018 Pakistan [message #28400] |
Wed, 27 December 2023 11:05 ![Go to next message Go to next message](/theme/default/images/down.png) |
khan88
Messages: 2 Registered: December 2023
|
Member |
|
|
Hi, Does anyone know code book to indentify household cluster or cluster numbers or any information beyound district numbers in DHS 2018-19 ? I am conducting research to see vulnerbality within districts i.e. require info for tehsil/villages within each districts, if that can be provided? Thank you
PS: I dont need any indentity information, just data like
District___Village or Tehsil codes/names so i can perform analysis within each district in Pakistan.
Regards
Dr. Khan
|
|
|
Re: Beyound District Infon in DHS data 2018 Pakistan [message #28420 is a reply to message #28400] |
Tue, 02 January 2024 12:10 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Janet-DHS
Messages: 829 Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
You can merge the HR file with the GE file using the cluster id in the HR file, hv001, and the cluster id in the GE file (the last three characters of DHSID; I will paste below the Stata lines to do this merge). If you have a shape file for Bangladesh that includes the district boundaries at the time of the 2017-18 survey, then you can identify which district each clusters is in. The latitude and longitude of the clusters (LATNUM and LONGNUM) have been displaced slightly, but they should have been kept within the same admin 2 units (districts).
* Merge the HR and GE files from the BD 2017-18 DHS survey
* Specify workspace
cd e:\DHS\DHS_data\scratch
use "...BDGE7SFL.DTA"
gen hv001=substr(DHSID,12,3)
destring hv001, replace
sort hv001
save temp.dta, replace
use "...BDHR7RFL.DTA"
sort hv001
merge hv001 using temp.dta
tab _merge
drop _merge
* Save the merged file with a new name
|
|
|