The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Percentage of households with at least 1 ITN
Percentage of households with at least 1 ITN Fri, 21 October 2016 14:52
 Ahmed M Kamel Messages: 5Registered: September 2016 Location: Egypt Member
Hi,
I have problem with calculating the ownership of insecticide Treated nets using Camaeroon DHS6 2011 Household Survey (CMHR60FL).
I used the Variables HML10\$1 to HML10\$7 and Summed them up to calculate the number of ITNs per each household then recoded it into a 0 if No ITNs and 1 if house hold has 1 or more ITNs.
I weighed variable using HV005 but for me i get a 7% as the proportion of households with ITNs vs 36% in the Cameroon DHS publication.
The variable i'm interested in is households with at least one insecticide treated net.
Thanks a lot.
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: 1350Registered: 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.

```

Re: Percentage of households with at least 1 ITN [message #11105 is a reply to message #11074] Thu, 27 October 2016 18:51
 Ahmed M Kamel Messages: 5Registered: September 2016 Location: Egypt Member
Thanks a lot, i'm getting the right percentage now. However, I now have a new problem that involves calculating the proportion of cgildren under 5 who slept under ITN treated nets.
I use CMPR60FL.SAV
I use filter //COMPUTE filter_2=(HML16A< 60 AND HV027=0)// to select children under 5 and also those who were not selected for male Questionnaire as you kindly recommended.
When i do // Freq HML12// or //Freq HML10// i get a 20.6% vs 21% in the DHS cameroon report. Thanks a lot. Can i consider using the brand of net as an indicatior for ITN?
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: 1350Registered: 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.

```

Re: Percentage of households with at least 1 ITN [message #11119 is a reply to message #11113] Sat, 29 October 2016 07:29
 Ahmed M Kamel Messages: 5Registered: September 2016 Location: Egypt Member
Thank you so much. All is fine now.
 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 Oct 21 22:03:38 Eastern Daylight Time 2018