The DHS Program User Forum: Nigeria » Utilization of insecticide treated nets by children under 5 in southwest Nigeria

Home » Countries » Nigeria » Utilization of insecticide treated nets by children under 5 in southwest Nigeria (Proportion of children who slept under mosquito nets, ITNs in south west Nigeria the night before the survey)

Show: Today's Messages :: Show Polls :: Message Navigator

Utilization of insecticide treated nets by children under 5 in southwest Nigeria [message #23083]

Sun, 11 July 2021 08:44

Esuabom
Messages: 1
Registered: July 2021

Member

I am having difficulty in calculating indicators for use of bed nets by children under 5 in southwest Nigeria using the HR dataset of the Nigeria DHS 2018. I have read the guidelines for DHS statistics but still encountering difficulties. I am using the SPSS for analysis.
secondly, the calculated indicators for fever in children under 5 in southwest Nigeria obtained by me were different from that in the NDHS 2018 report. I used the KR file of the NDHS 2018 but for instance, total children in southwest Nigeria was 3533 in my dataset as opposed to 4185 in the NDHS report.

Report message to a moderator

Re: Utilization of insecticide treated nets by children under 5 in southwest Nigeria [message #23103 is a reply to message #23083]

Tue, 13 July 2021 15:42

Bridgette-DHS
Messages: 3199
Registered: February 2013

Senior Member

Following is a response from DHS Lead Malaria Research Analyst, Cameron Taylor:

You can find the malaria chapter SPSS code on our website https://github.com/DHSProgram/DHS-Indicators-SPSS/tree/maste r/Chap12_ML

To calculate the "Percentage of children under age 5 who slept the night before the survey under an ITN" you need to use the PR file (NGPR7AFL). Your denominator/unit of analysis for this indicator is CHILDREN or PEOPLE. When you use the HR file your unit of analysis is households. The following video might be of help: https://www.youtube.com/watch?v=JGRJZCGiCJw

The following code matches 2018 Nigeria DHS final report Table 12.7. I have also included code to match Table 12.11 "Percentage of children under age 5 with a fever in the 2 weeks preceding the survey" using NGKR71FL.

CODE TO RECREATE TABLE 12.7
*Categorizing nets.
if hml12=0 ml_netcat=0 .
if hml12=1|hml12=2 ml_netcat=1. 
if hml12=3 ml_netcat=2.
variable labels  ml_netcat "Mosquito net categorization".


*Slept under an ITN last night.
compute ml_slept_itn=(ml_netcat=1).
variable labels  ml_slept_itn  "Slept under an ITN last night".
value labels ml_slept_itn 0 "No" 1 "Yes".

compute wt=hv005/1000000.

weight by wt.

****************************************************.
compute filter = (hv103=1 & hml16<5).
filter by filter.

crosstabs 
    /tables = hv104 hv025 hv024 hv270 by ml_slept_itn 
    /format = avalue tables
    /cells = row 
    /count asis.

CODE TO RECREATE TABLE 12.11
do if b5<>0.
+compute ml_fever=(h22=1).
end if.
variable labels ml_fever "Fever symptoms in the 2 weeks before the survey".
value labels ml_fever 0 "No" 1 "Yes".

compute wt=v005/1000000.

weight by wt.

* create denominators.
compute num=1.
variable labels num "Number".

execute.

compute age=b19.

recode age (0 thru 11=1) (12 thru 23=2) (24 thru 35=3) (36 thru 47=4) (48 thru 60=5) into agecat.
variable labels agecat "Age".
value labels agecat 1 "<12" 2 "12-23" 3 "24-35" 4 "36-47" 5  "48-59".

****************************************************.

crosstabs 
    /tables = agecat b4 v025 v024 v106 v190 by ml_fever
    /format = avalue tables
    /cells = row 
    /count asis.

Report message to a moderator

Previous Topic:	CMC format to month/year
Next Topic:	Nigeria percentage breakdown of indicators

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Nov 23 04:42:58 Coordinated Universal Time 2024