The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Linking fever to malaria
Linking fever to malaria [message #10573] Thu, 11 August 2016 09:55 Go to next message
corey2kimzey is currently offline  corey2kimzey
Messages: 2
Registered: June 2016
I'm currently doing a project on malaria in Benin. I would like to be able to use the variable of "fever in the last two weeks" but this is only found in the children record data set. Currently I'm using the household individual data set to get the results of the malaria testing. If any one could help explain to me how I can link these two variables into the same data set, that would be great.
Re: Linking fever to malaria [message #10582 is a reply to message #10573] Fri, 12 August 2016 15:33 Go to previous message
Messages: 1350
Registered: February 2013
Senior Member
A response from malaria expert, Cameron Taylor:

Dear Corey,
You are correct that the questions about "fever in the last two weeks" is only found in the KR dataset and parasitemia data located in the PR dataset. It is important to note that questions on fever are asked about children 0-59 months of age of interviewed women for a period of two weeks before the survey whereas malaria parasitemia testing is done on all eligible, consented children 6-59 months of age in the household whether or not his/her mother is interviewed. Thus if you are linking fever and parasitemia your analyses is limited to children born to interviewed mothers who had valid test results for microscopy or RDT (depending on which measure you are using).

That being said it is possible to link fever and parasitemia by merging the PR and KR files for Benin. You can read more about merging datasets on our website.

To merge the PR and KR files you will need to rename the unique identifiers in the PR file for cluster, household and line number to match the KR file. Please keep in mind that there will be children that do not properly merge because this merge will produce unmatched observations (children who were tested for malaria but their mothers were not interviewed as part of the women's questionnaire so we do not have information about recent fevers in the PR but not the KR as well as children of interviewed mothers for whom we do not have parasitemia data in the KR but not the PR).

Let us know if you have any additional questions

Previous Topic: Missing Data Points in Benin 2011-2012 Survey
Next Topic: Ghana DHS 2014 HML32 (malaria microscopy missing)
Goto Forum:

Current Time: Sat Oct 20 22:20:23 Eastern Daylight Time 2018