| Malaria Treatment Variable [message #11677] |
Thu, 26 January 2017 16:03  |
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  |
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!
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
