The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Prevention of Malaria( ITP in pregnancy)
Prevention of Malaria( ITP in pregnancy) [message #12446] Thu, 18 May 2017 12:19 Go to next message
kambi is currently offline  kambi
Messages: 10
Registered: May 2017
Location: bruxelles
Member
Dear Team ,

I am using dataset of DRCongo (DSH 2013-2014 : CDBR61FL) on the use of ITP in pregnancy in the case of prevention.
I want to know how to create Two dependent variables that include the number of women (15-49) with a live birth in the last two years preceding the survey who:

1) took 2 or more doses of SP (sulfadoxine-Pyrimethamin) and who received at least one doses during an antenatal visit,

2) received the SP during an antenatal visit.

I read some DHS manuals without understanding some things.
I recoded theses variables M14 ,m49a,ml2 and i merged them in stata but I can't arrive to find these two variables.How could you do for recoding theses outcomes.

Thanks for your help

Fiston


kambishokamoyafiston001

[Updated on: Thu, 18 May 2017 19:09]

Report message to a moderator

Re: Prevention of Malaria( ITP in pregnancy) [message #12469 is a reply to message #12446] Tue, 23 May 2017 10:00 Go to previous messageGo to next message
Liz-DHS
Messages: 1264
Registered: February 2013
Senior Member
A response from malaria expert, Cameron Taylor:
Quote:

Dear user,
Thanks for your question. To begin with you need to be using the IR file (CDIR61FL) instead of the BR file (CDBR61FL). For the IPTp indicator the unit of analysis is women so you need to be using the women's file. You can find more information about DHS datasets at the following videos.

Introduction to DHS datasets: https://www.youtube.com/watch?v=fzLNQkkvDeI
Introduction to DHS Data Structure: https://www.youtube.com/watch?v=BmiSDPebmgc

Once in the IR file you will then need to consider the following variables in your indicator calculation:
• 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)

Regards
Cameron

Re: Prevention of Malaria( ITP in pregnancy) [message #12471 is a reply to message #12469] Tue, 23 May 2017 11:14 Go to previous messageGo to next message
kambi is currently offline  kambi
Messages: 10
Registered: May 2017
Location: bruxelles
Member
Dear Cameron ,

I followed these two videos but I want to know if there will be a difference in the results by using the BR file, instead of IR file because this BR file includes all births related to the women interviewed , What kind of problems am I going to find in this case?
And 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 ?

I will contact you again for some explanations.

Thanks you for your answer Cameron

FISTON


kambishokamoyafiston001

[Updated on: Tue, 23 May 2017 13:04]

Report message to a moderator

Re: Prevention of Malaria( ITP in pregnancy) [message #12703 is a reply to message #12471] Fri, 30 June 2017 17:04 Go to previous messageGo to next message
Liz-DHS
Messages: 1264
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]


Re: Prevention of Malaria( ITP in pregnancy) [message #12711 is a reply to message #12703] Mon, 03 July 2017 11:30 Go to previous messageGo to next message
kambi is currently offline  kambi
Messages: 10
Registered: May 2017
Location: bruxelles
Member
Dear Cameron Taylor and Liz ,


Thank you very much for your help.
I'm using now the women recode (IR) file and I saw your answer but why did you put 97 in your syntax when you created "sptwoanc" (you can see the table of ml1_1).
For our code DRC ,I tried theses syntax and I got now 7168 for the proportion of women who received two or more doses of IPTp during their last pregnancy in the last two years but I have a problème to reproduce the descriptive table ,how can I reproduce the result as in the report for example "the descriptive of age" because I don't able to have the correct table of description as in the report (for example "Tab V013")

Thank you a lot

Fiston Kambi



kambishokamoyafiston001

[Updated on: Mon, 03 July 2017 11:32]

Report message to a moderator

Re: Prevention of Malaria( ITP in pregnancy) [message #12712 is a reply to message #12711] Mon, 03 July 2017 11:46 Go to previous messageGo to next message
kambi is currently offline  kambi
Messages: 10
Registered: May 2017
Location: bruxelles
Member
[quote title=kambi wrote on Mon, 03 July 2017 17:30]Dear Cameron Taylor and Liz ,


Thank you very much for your help.
I'm using now the women recode (IR) file and I saw your answer but i want to know why did you put 97 in your syntax when you created "sptwoanc" (you can see the table of ml1_1).
For our code DRC ,I tried theses syntax and I got now 7168 for the proportion of women who received two or more doses of IPTp during their last pregnancy in the last two years but the problème is now to reproduce the descriptive table,how can I reproduce the result as in the report for example "the descriptive of v013" because I reproduce the descriptive table with the old proportion of 18827.It does not take into account the new proportion of women who have had a birth in the last two years.

Thank you a lot

Fiston Kambi


kambishokamoyafiston001
Re: Prevention of Malaria( ITP in pregnancy) [message #12713 is a reply to message #12712] Mon, 03 July 2017 11:47 Go to previous messageGo to next message
kambi is currently offline  kambi
Messages: 10
Registered: May 2017
Location: bruxelles
Member
[quote title=kambi wrote on Mon, 03 July 2017 17:46][quote title=kambi wrote on Mon, 03 July 2017 17:30]Dear Cameron Taylor and Liz ,


Thank you very much for your help.
I'm using now the women recode (IR) file and I saw your answer but i want to know why did you put 97 in your syntax when you created "sptwoanc" (you can see the table of ml1_1).
For our code DRC ,I tried theses syntax and I got now 7168 for the proportion of women who received two or more doses of IPTp during their last pregnancy in the last two years but the problème is now to reproduce the descriptive table,how can I reproduce the result as in the report for example "the descriptive of v013" because I reproduce the descriptive table with the old proportion of 18827.It does not take into account the new proportion of women who have had a birth in the last two years.

Thank you a lot

Fiston KAMBI


kambishokamoyafiston001
Re: Prevention of Malaria( ITP in pregnancy) [message #12714 is a reply to message #12713] Mon, 03 July 2017 12:19 Go to previous messageGo to next message
kambi is currently offline  kambi
Messages: 10
Registered: May 2017
Location: bruxelles
Member
Dear Cameron Taylor and Liz ,


Thank you very much for your help.
I'm using now the women recode (IR) file and I saw your answer but i want to know why did you put 97 in your syntax when you created "sptwoanc" (you can see the table of ml1_1).
For our code DRC ,I tried theses syntax and I got now 7168 for the proportion of women who received two or more doses of IPTp during their last pregnancy in the last two years but the problème is now to reproduce the descriptive table,how can I reproduce the result as in the report for example "the descriptive of v013" because I reproduce the descriptive table with the old proportion of 18827.It does not take into account the new proportion of women who have had a birth in the last two years.

Thank you a lot

Fiston kambi


kambishokamoyafiston001
Re: Prevention of Malaria( ITP in pregnancy) [message #13168 is a reply to message #12714] Sun, 01 October 2017 00:25 Go to previous message
Liz-DHS
Messages: 1264
Registered: February 2013
Senior Member
Dear User,
Do you still need assistance to this post?
Thank you!
Previous Topic: Malaria microscopy results MIS 2016 Ghana
Next Topic: Ghana 2016
Goto Forum:
  


Current Time: Sun Jul 15 21:11:59 Eastern Daylight Time 2018