The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Malaria in pregnancy
Malaria in pregnancy [message #12493] Mon, 29 May 2017 11:50 Go to next message
kambi is currently offline  kambi
Messages: 10
Registered: May 2017
Location: bruxelles
Dear team

I work on the CDBR61FL (DHS RDCcongo), by calculating v008-b3 to find the number of women with a birth in the last two years, I don't get the same result as in the Table 12.8 (Result=7168) :

gen age_new=v008-b3_1
keep if age_new <24
tab age_new
(Result = 7154) ,a difference of 14 with what is in the table 12.8 of final report,is it correct the way I calculate ? Can you help with a good syntax for getting correct result.

-I want you to help me to create the variable on le number of women (15-49) with a live birth in th two years preceding the survey who took 2 or more doses of SP (Sulfadoxine-pyrimethamine) and who received at least one dose during an antenatalvisit.

Thanks you for your answer


Re: Malaria in pregnancy [message #12672 is a reply to message #12493] Wed, 28 June 2017 22:12 Go to previous messageGo to next message
Messages: 1123
Registered: February 2013
Senior Member
Dear User,
Please refer to the Guide to DHS Statistics. It contains a lot of useful information for structuring your analysis. It can be found on our website:http:// onnaires-and-manuals.cfm
There is also the Standard Recode Manual: http:// onnaires-and-manuals.cfm
Using Data Sets for analysis:
For data users who are having trouble matching the denominators for the child-related tables in the newest surveys, may find this link useful

Other useful resources, a series of YouTube videos:
DHS Dataset Types in 60 Seconds:
Introduction to DHS Datasets:
Introduction to DHS Data Structure:
De Jure and De Facto:

Please review all these resources as well as other posts on the forum by searching for Keywords. After reviewing, if you still have questions, please feel free to post again.
Thank you!

Re: Malaria in pregnancy [message #12702 is a reply to message #12493] Fri, 30 June 2017 17:02 Go to previous message
Messages: 1123
Registered: February 2013
Senior Member
A response from senior malaria expert, Cameron Taylor:

Dear Fiston,
To calculate the IPTp indicator you need to be using the Individual Recode (IR) file since the denominator is "Effectif de femmes ayant eu une naissance au cours des deux années avant l'enquête". The IR file has one row for every woman age 15-49 which you are limiting to women who have had a birth in the past two years. As I noted in your previous post you need to make sure you account for:
• During pregnancy took SP/fansidar (m49a_1)
• Took 2+ doses (ml1_1)
• Source of antimalarial (ml2_1)
• Had a delivery of a live baby within the last two years (Date of interview- Date of Birth) or (v008-b3_01)

You can replicate it using the following code for DRC
use "CDIR61FL.DTA", clear

                g wgt = v005/1000000

*Establishing birth in past 2 years
                g agemnth=.
                replace agemnth=v008-b3_01
                lab var agemnth "Establishing birth in past 2 years"
*two or more doses sp/fansidar during anc visit
                g sptwoanc=0
                replace sptwoanc=1 if m49a_1==1 & (ml1_1 >=2) & (ml1_1<=97) & (ml2_1==1)
*Proportion of women who received two or more doses of IPTp during their last pregnancy in the last two years, at least one dose of which was received as part of an ANC visit**
tab sptwoanc if agemnth < 24 [iweight=wgt]

Previous Topic: What are sample sizes for MIS based on?
Next Topic: Malaria diagnosis results for children in sierra leone
Goto Forum:

Current Time: Tue Jan 23 00:57:08 Eastern Standard Time 2018