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)
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: 938
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%
 
Read Message
Read Message
Previous Topic: About pooled analyses
Next Topic: ARI data and commands in STATA
Goto Forum:
  


Current Time: Thu May 15 10:05:39 Coordinated Universal Time 2025