The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Questions about 2004 Malawi and 2005 Rwanda child health indicators (Calculations)
Questions about 2004 Malawi and 2005 Rwanda child health indicators [message #30364] Wed, 13 November 2024 07:55 Go to next message
erica is currently offline  erica
Messages: 1
Registered: November 2024
Member
Hi, we are doing a study on iCCM and were looking back retrospectively at some data in Malawi (2004) and Rwanda (2005) for fever care seeking and ARI care seeking. In the 2004 Malawi report, we are only finding 'Among children with symptoms of ARI and/or fever, percentage who sought treatment." We are looking for fever and ARI care-seeking individually. When we look at the raw data and calculate the those variables and then try to combine them to cross-reference with what is in the report, we are not getting the same figure of 19.6%. Could you provide us any insights on this and how we can get those indicators individually. We are then trying to get care-seeking from CHW, which we are able to calculate individually in the raw data.

Similarly for Rwanda 2005, the report does not report fever care-seeking and ARI care-seeking individually but as combined into one indicator. When we run it in the raw data, we are able to get individual indicator values but when we try to combine we are not getting the same value as the report which is 26.9. We have the correct code so are confused at why this is happening.
Re: Questions about 2004 Malawi and 2005 Rwanda child health indicators [message #30375 is a reply to message #30364] Fri, 15 November 2024 19:44 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 901
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

I will paste below Stata lines that DO give the 19.6% for the Malawi 2004 survey, with additional lines showing how to get separate percentages treated for children having fever or having cough (ARI symptoms). I suspect that your issue was in how to distinguish between NA and 0 for the joint indicator of fever or cough, i.e. fever and/or cough.  I have not tested this for the Rwanda survey.  Please let me know if you still have questions.

* Match table 9.16 in Malawi 2004 report

 

use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\MWKR4EFL.DTA", clear

gen wt=v005/1000000

 

* Construct binary outcome for had fever

gen     fever=0 if h22<.

replace fever=1 if h22==1

tab     fever [iweight=wt],m

* Matches 18.8%

 

* Construct binary outcome for had cough

gen     cough=0 if h31<.

replace cough=1 if h31b==1

tab     cough [iweight=wt]

* Matches 37.1%

 

* Construct binary outcome for had fever or cough

gen     fever_cough=0 if fever<. & cough<.

replace fever_cough=1 if fever==1 | cough==1

tab fever_cough [iweight=wt]

 

* Construct binary outcome for whether had medical treatment,

*   given had fever or cough

gen     treatment_for_fever_cough=0 if fever_cough==1

replace treatment_for_fever_cough=1 if fever_cough==1 & h32z==1

tab treatment_for_fever_cough [iweight=wt]

* Matches 19.6% and 4360

 

* Extend to separate binary outcomes for whether had medical treatment,

*   given had fever OR given cough

gen     treatment_for_fever=0 if fever==1

replace treatment_for_fever=1 if fever==1 & h32z==1

tab treatment_for_fever [iweight=wt]

* Gives 15.9%

 

gen     treatment_for_cough=0 if cough==1

replace treatment_for_cough=1 if cough==1 & h32z==1

tab treatment_for_cough [iweight=wt]

* Gives 36.5%
Previous Topic: About pooled analyses
Next Topic: ARI data and commands in STATA
Goto Forum:
  


Current Time: Wed Dec 11 16:04:19 Coordinated Universal Time 2024