The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Disability in HR with characteristics from IR and MR (Get the disability details from HR file into IR and MR files)
Re: Disability in HR with characteristics from IR and MR [message #26670 is a reply to message #26660] Fri, 14 April 2023 11:34 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:

We don't get many questions about these variables. Glad you are using them. I will paste below some Stata lines that you can run on the PR file (not the HR file) to re-state the variables in terms of the lines numbers in the PR file (hvidx). Without some such reshaping it will be hard to use the disability data. The file constructed with these lines will be ready for a merge with the IR or MR files AFTER you have renamed state, cluster, hh, line (for example, v024, v001, v002, v003 in the IR file) and sorted.

The disability questions are asked for a maximum of 4 people (not 6) in a household that is reported to have one or more people with a disability. Please check the report and the questionnaire for more information about the selection and interpretation.

use "...IAPR7DFL.DTA", clear

gen dis_hearing  =9
gen dis_speech   =9
gen dis_visual   =9
gen dis_mental   =9
gen dis_locomotor=9
gen dis_other    =9

local letters "a b c d"

foreach ll of local letters {
replace dis_hearing  =sh33`ll'1a if sh33`ll'==hvidx
replace dis_speech   =sh33`ll'1b if sh33`ll'==hvidx
replace dis_visual   =sh33`ll'1c if sh33`ll'==hvidx
replace dis_mental   =sh33`ll'1d if sh33`ll'==hvidx
replace dis_locomotor=sh33`ll'1e if sh33`ll'==hvidx
replace dis_other    =sh33`ll'1x if sh33`ll'==hvidx
}

label define dis 0 "No" 1 "Yes" 8 "DK" 9 "No one in hh has a disability"
label values dis_hearing    dis
label values dis_speech    dis
label values dis_visual    dis
label values dis_mental    dis
label values dis_locomotor dis
label values dis_other     dis


keep hv024 hv001 hv002 hvidx dis*
gen state=hv024
gen cluster=hv001
gen hh=hv002
gen line=hvidx
sort state cluster hh line 
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: DHS Pakistan 2017-2018
Next Topic: Merging IR and HR files for Bangladesh
Goto Forum:
  


Current Time: Tue Nov 26 10:49:14 Coordinated Universal Time 2024