Percentage of households with at least 1 ITN [message #11054] |
Fri, 21 October 2016 14:52 |
Ahmed M Kamel
Messages: 5 Registered: 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: 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.
|
|
|
|
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.
|
|
|
|