]]>
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.
]]>
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.