The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Malaria Treatment Variable
Malaria Treatment Variable [message #11677] Thu, 26 January 2017 16:03 Go to next message
cbdolan is currently offline  cbdolan
Messages: 17
Registered: March 2013
Location: Williamsburg, VA
Member
Hello,

I have accessed the Malawi 2012 MIS (Individual Recode) and want to create an outcome variable that includes treatment for child fever in the last two weeks.

Before constructing the variable I want to make sure I understand the coding within the dataset.

In the individual recode there are 6 variables (s404a_1-6) corresponding to days ago fever started, then 6 treatment variables (s406a1-6). Am I correct that this is one women and up to 6 kids which treatment information is collected? For example s404a_1 is the number of days the fever started and then s406a1 is that same kid and the number of days after the fever began treatment was sought. Following that pattern s404a_2 goes with s406a2...s404a3 goes with s406a3...

Is there a better way to construct malaria treatment behavior or am I on the right track?

Thanks,

Carrie
Re: Malaria Treatment Variable [message #11692 is a reply to message #11677] Mon, 30 January 2017 10:19 Go to previous message
cbdolan is currently offline  cbdolan
Messages: 17
Registered: March 2013
Location: Williamsburg, VA
Member
Hello,

I found post #8930 and now understand that the MIS is constructed in similar recode files to the standard DHS (ie. IR, PR, KR...). I also now understand the merge is similar and have correctly merged the 2013 PR and KR using the following code:

use Z:\Data\DataIn_Original\2_DHS_MIS\MWKR6HDT_MIS\MWKR6HFL.dta, clear
gen hv001=v001
gen hv002=v002
gen hvidx=b16
sort hv001 hv002 hvidx
save Z:\Data\DataIn_Original\0_Scratch\temp.dta, replace

use Z:\Data\DataIn_Original\2_DHS_MIS\MWPR6HDT_MIS\MWPR6HFL.dta, clear
sort hv001 hv002 hvidx
merge hv001 hv002 hvidx using Z:\Data\DataIn_Original\0_Scratch\temp.dta
tab _merge
keep if _merge==3
drop _merge

*N=2171

No response to this post is necessary.

Thanks!
Previous Topic: Mosquito nets
Next Topic: 2011 Cameroon Demographic Health Survey
Goto Forum:
  


Current Time: Thu Jul 19 13:21:34 Eastern Daylight Time 2018