The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Number of women with a live birth in the two years preceding the survey
Number of women with a live birth in the two years preceding the survey Wed, 10 May 2017 12:38
 wawa20 Messages: 9Registered: December 2016 Location: Taipei Member
Dear Team,

I want to calculate the sample size for my study and as the title above, I want to know how I can calculate the number of women with a
live birth in the two years preceding the survey and which is the appropriate table to use to match with in the final report of Malaria Indicator Survey 2014 - Malawi. Currently am using table 3.7 in Malawi MIS 2014 final report which gives me a total of 945 cases. Is this the right table to use? From my side consultations, I am also using the IR file, and to calculate women with a live birth in the last 2 years, I am computing valuables v008-b3 and then selecting those living with mother (b9=0) and finally selecting my new age valuable to <24 . But my figures are not matching with the 945 from the table, I suspect because I am not able to apply the sampling weights or am using the wrong valuables to calculate. Would someone please explain to me how I can calculate this figure are and what are the spss commands to use in order to calculate this percentage?

Regards,
Re: Number of women with a live birth in the two years preceding the survey [message #12406 is a reply to message #12403] Wed, 10 May 2017 17:16
 Liz-DHS Messages: 1516Registered: February 2013 Senior Member
Dear User,
I would start by viewing the YouTube videos:
Matching DHS Tables tutorial videos on YouTube. The video series covers the top 7 tips and tricks to successfully matching The DHS Program Final Reports using a statistical software program. There are 4 videos total that average around 5 minutes long.
The video series covers making sure you have the correct....
Video 1: Data File and Denominator
Video 2: Variables
Video 3: Recoding and Weights
Video 4: Software Specific Codes and Tabulation Commands
Other resources: The Guide to DHS Statistics http:// www.dhsprogram.com/publications/publication-dhsg1-dhs-questi onnaires-and-manuals.cfm
The Standard Recode Manual http:// www.dhsprogram.com/publications/publication-DHSG4-DHS-Questi onnaires-and-Manuals.cfm
Using Datasets for Analysis http://www.dhsprogram.com/data/Using-Datasets-for-Analysis.cfm and
For SPSS Tutorial: https:// www.ibm.com/support/knowledgecenter/en/SSLVMB_24.0.0/statist ics_spsstut_project_ddita-gentopic1.html

Re: Number of women with a live birth in the two years preceding the survey [message #12441 is a reply to message #12406] Thu, 18 May 2017 05:16
 wawa20 Messages: 9Registered: December 2016 Location: Taipei Member
Dear Liz,

Thanks for the links, so far they have been helpful. I am using the IR file for the MIS 2014 Dataset for Malawi. I tried calculating % of pregnant women in the last 2 years by using the following commands in stata;

gen newage=v008 - b3_01
keep if b9_01==0
ta newage<24[iw=v005/1000000]

The total am getting is 940 pregnant women (See the table below). However, from the Malawi MIS 2014 final report Table 3.7, the total number of pregnant women the last 2 years is 945. Am I missing anything in my calculation?

newage Freq. Percent Cum.

0 13.005921 1.38 1.38
1 36.353604 3.86 5.25
2 25.833501 2.75 7.99
3 39.389364 4.19 12.18
4 43.978862 4.68 16.86
5 66.794732 7.10 23.96
6 27.435501 2.92 26.87
7 55.091184 5.86 32.73
8 29.091278 3.09 35.82
9 32.295051 3.43 39.25
10 30.375328 3.23 42.48
11 43.74883 4.65 47.13
12 33.841958 3.60 50.73
13 27.562094 2.93 53.66
14 50.419004 5.36 59.02
15 34.407542 3.66 62.68
16 56.78511 6.04 68.72
17 30.337444 3.22 71.94
18 49.372125 5.25 77.19
19 37.533042 3.99 81.18
20 57.818431 6.15 87.32
21 49.946537 5.31 92.63
22 31.065515 3.30 95.94
23 38.227323 4.06 100.00

Total 940.709281 100.00

Regards,
Re: Number of women with a live birth in the two years preceding the survey [message #12448 is a reply to message #12441] Thu, 18 May 2017 13:43
 Liz-DHS Messages: 1516Registered: February 2013 Senior Member
A response from malaria expert, Cameron Taylor:
Quote:

Dear User,
Great question, to solve your problem you don't need to exclude to only children that are living with their mothers. The information about IPTp is based on recall so this contains information about children who are living with their mother, children away from their mother, or even children (who were their mothers most recent pregnancy) who have passed away in the previous 2 years.

Let us know if you have any additional questions
Cameron

Re: Number of women with a live birth in the two years preceding the survey [message #12497 is a reply to message #12448] Tue, 30 May 2017 05:33
 wawa20 Messages: 9Registered: December 2016 Location: Taipei Member
Dear Liz and Cameron Taylor,

Thank you. I am now able to follow, if i have further questions I will post them here.

Thanks!

 Previous Topic: Antimalarial - Afghanistan 2015 Next Topic: ACT - Malawi 2015
Goto Forum:

Current Time: Sat Nov 26 12:02:53 Coordinated Universal Time 2022