| Number of women with a live birth in the two years preceding the survey [message #12403] |
Wed, 10 May 2017 12:38  |
|
|
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 #12441 is a reply to message #12406] |
Thu, 18 May 2017 05:16  |
|
|
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: 1516
Registered: 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
|
|
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
