Re: Percentage of households with at least 1 ITN [message #11074 is a reply to message #11054] |
Mon, 24 October 2016 12:22 |
Liz-DHS
Messages: 1516 Registered: February 2013
|
Senior Member |
|
|
A response from Malaria Expert, Cameron Taylor:
Quote:
Dear Ahmed M Kamel,
Thank you for your question. You are correct in the way you were initially calculating the indicator, however, the Cameroon DHS 2011 survey is a little bit different than other DHS surveys due to the sample design. If you look on page 13 of the final report you will see a diagram on the organization of the survey. "Protection contre moustiques" is only asked of 50% of households. In other words it was only asked of households NOT selected for the male questionnaire. Below is the SPSS syntax for further clarification. I used a loop to create the ITN in households variable but your code will work as well.
Let us know if you have any additional questions
*// Weighting table.
compute wt= hv005/1000000.
weight by wt.
*// ITN variable creation in HR file.
COMPUTE ITNinHH = 0.
VECTOR HML10 = HML10$1 TO HML10$7.
LOOP i = 1 to 7.
+ IF ( HML10(i) = 1) ITNinHH = 1.
END LOOP.
VARIABLE LABELS ITNinHH "Household own at least one ITN".
*// Selecting only households not selected for the men's questionniare.
SELECT IF hv027=0.
freq ITNinHH.
|
|
|