The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in SPSS » Kenya Malaria Indicator Survey 2015 (Replicating Table 6.2 Prevalence of malaria in children)
Kenya Malaria Indicator Survey 2015 [message #16704] Thu, 21 February 2019 21:13 Go to next message
nmutai is currently offline  nmutai
Messages: 1
Registered: February 2019
Dear sir/madam,

I am working on the Kenya Malaria Indicator Survey of 2015. First, how does one uniquely identify children in the data? And secondly, trying to replicate the results of Table 6.2, but getting a figure of 9058 by RDT and 9074 by microscopy. These are weighted. Please help.
Re: Kenya Malaria Indicator Survey 2015 [message #16970 is a reply to message #16704] Thu, 14 March 2019 15:00 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3066
Registered: February 2013
Senior Member
Following is a response from DHS Lead Malaria Research Analyst, Cameron Taylor:

Dear user,
Thanks for your question, since you are wanting to examine parasitemia you should be using the PR file since this file includes all household members (not just kids whose mothers were interviewed). You can learn more about DHS data files in the following YouTube video list=PLagqLv-gqpTNBR0KcyrajAqKrFdsdIqqe

To match Kenya MIS malaria table 6.2 it is important to look at the table description. Unlike other countries, Kenya MIS sampled children 6 months to 14 years. In most DHS surveys we only sample children 6 months to 5 years old. Because of this difference country specific age variables were created for Kenya. Country specific variables always start with the letter "s"

use KEPR7AFL.dta, clear

                gen micmalpos=0
                replace micmalpos=(hml32==1) 
                lab var micmalpos "Parasitemia (via microscopy)"
                gen rdtmalpos=0
                replace rdtmalpos=(hml35==1) 
                lab var rdtmalpos "Parasitemia (via RDT) "

* Proportion of children 6 months to 14 years with malaria infection (RDT)
tab rdtmalpos if shml16a>=6 & shml16a<=179 & hv103==1 & hml33==0 & hml35!=6 [iweight=wgt]

* Proportion of children 6 months to 14 years with malaria infection (microscopy)
tab micmalpos if shml16a>=6 & shml16a<=179 & hv103==1 & (hml32==0|hml32==1)  [iweight=wgt]
Previous Topic: Postnatal care utilization variable in 2015-2016 MDHS dataset
Next Topic: Spss syntax to generate table 4.3 Ghana DHS 2014
Goto Forum:

Current Time: Wed May 29 21:16:59 Coordinated Universal Time 2024