Malaria in pregnancy [message #12493] |
Mon, 29 May 2017 11:50 |
kambi
Messages: 10 Registered: May 2017 Location: bruxelles
|
Member |
|
|
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
FISTON KAMBI
kambishokamoyafiston001
|
|
|
|
Re: Malaria in pregnancy [message #12702 is a reply to message #12493] |
Fri, 30 June 2017 17:02 |
Liz-DHS
Messages: 1516 Registered: February 2013
|
Senior Member |
|
|
A response from senior malaria expert, Cameron Taylor:
Quote:
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
*Weighting
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]
|
|
|