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)
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: 3039
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 https://www.youtube.com/watch?v=fzLNQkkvDeI&index=7& 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]
 
Read Message
Read Message
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 Apr 24 21:53:42 Coordinated Universal Time 2024