Re: Percentage of households with at least 1 ITN [message #11113 is a reply to message #11105] |
Fri, 28 October 2016 14:12 |
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.
|
|
|