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 #11074 is a reply to message #11054] Mon, 24 October 2016 12:22 Go to previous messageGo to previous message
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.


 
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: Sun Jun 16 18:29:56 Coordinated Universal Time 2024