The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Malaria
Re: Malaria [message #14500 is a reply to message #14484] Fri, 13 April 2018 08:02 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 DHS Senior Research Associate, Cameron Taylor:


If you are wanting to calculate ITN Ownership you would need to use the HR file. This is because the unit of analysis is the household. When you see hml10_1 that is net treatment information about net 1, hml10_2 is the net treatment information about net 2, etc. It is broken into separate variables because each row in the dataset is a household.

If you are wanting to calculate ITN Use you need to use the PR file. This is because the unit of analysis is people so the information is about the net that person slept under the previous night. I have included the information below how to calculate children <5 sleeping under an ITN the previous night in the PR file and ITN ownership in the HR file.

Please be cautious when analyzing data that is in a PR/KR merge. There are kids in the PR file for whom we don't have information in the KR file. Remember that the information in the KR file is only from children <5 of interviewed mothers. If the mother wasn't interviewed we don't have that information. For example we might know if they slept under an ITN the previous night but we don't have information about their fever history etc.

*ITN USE in PR FILE
use PRfile.dta
g wt = hv005/1000000

**ITN used the night before the survey
g itn=(hml12==1)
lab var itn "ITN used the night before the survey"

* Proportion of children under 5 years old who slept under an ITN the previous night
tab itn if hv103==1 & hml16<5 [iweight=wt]


*ITN OWNERSHIP in HR File
use HRfile.dta
g wt = hv005/1000000

egen ITNinHH = rowmax(hml10_1-hml10_7)
replace ITNinHH=0 if ITNinHH==.

* Proportion of households with at least one ITN
tab ITNinHH [iweight=wt]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: District level Individual panel data
Next Topic: Final Estimates of Stunting
Goto Forum:
  


Current Time: Fri Nov 22 12:35:07 Coordinated Universal Time 2024