The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Percentage of households with at least 1 ITN
Re: Percentage of households with at least 1 ITN [message #11113 is a reply to message #11105] Fri, 28 October 2016 14:12 Go to previous messageGo to previous message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Malaria expert, Cameron Taylor responded:
Quote:

Dear User,
You were so close in your calculation! The part you are missing is that you need to restrict the tabulation to include only children who spent the previous night in the household (de facto children) in addition to children <5 years of age and households not included in the male questionnaire.

I am including my SPSS code below but if you add the restriction (SELECT IF hv103=1) you will match the Cameroon final report.
*// Weighting table.
compute wt= hv005/1000000.
weight by wt.

*//Recoding HML12 variable.
RECODE  HML12
                (0 = 0) (3 = 0) (1 = 1) (2 = 1)
                INTO itn .
VARIABLE LABELS itn "ITN used the night before the survey".
EXECUTE.

TEMPORARY.
*// Selecting only households not selected for the men's questionniare. 
SELECT IF hv027=0.
*// Selecting children who spent the previous night and under age 5.
SELECT IF hv103=1 & hml16<5.

*//Tabulation of ITN use by children <5 years of age.
freq itn.


 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ITN/untreated bednets in Household Members (PR) dataset
Next Topic: How to declare data survey with complex design by Stata
Goto Forum:
  


Current Time: Wed Jun 26 00:55:34 Coordinated Universal Time 2024