The DHS Program User Forum
Discussions regarding The DHS Program data and results
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)
Utilization of insecticide treated nets by children under 5 in southwest Nigeria [message #23083] Sun, 11 July 2021 08:44 Go to next message
Esuabom is currently offline  Esuabom
Messages: 1
Registered: July 2021
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.
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 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2945
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 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:

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.

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

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

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


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


    /tables = agecat b4 v025 v024 v106 v190 by ml_fever
    /format = avalue tables
    /cells = row 
    /count asis.      
Previous Topic: CMC format to month/year
Next Topic: Nigeria percentage breakdown of indicators
Goto Forum:

Current Time: Wed Dec 6 15:45:19 Coordinated Universal Time 2023