Hie Mluleki,
I managed to calculate the breastfeeding practices (early initiation of breastfeeding, exclusive breastfeeding) using the syntax that you gave me. However, am faced with the challenge of calculating bottle feeding. I tried applying the syntax for bottle feeding using the two separate data files but it still doesn't match that of the report. Any suggestions on how I can go about it?. Below is the syntax that I used:

I am trying to replicate Table 11.3 in the Rwanda DHS 2014-2015. I have followed the SPSS syntax given in this thread, however, I did not get the exact result like in the report. Some percentages differ.
When I look at my output table (attached here), I realized I do not have the first column of 'not breastfeeding' as in the report. I know that first column includes missing values also, can you please help me to know where I am getting it wrong? And also how do I take into account missing values in the SPSS syntax?

Following is a response from Senior Data Processing Specialist, Ladys Ortiz:

The main difficulty with this table is identifying the last child living with the mother. There are very few cases where the youngest child under age 2 is not leaving with their mother. Those few cases are the ones preventing you to match your number with table 11.3. If the youngest child (MIDX=1) is not leaving with the mother or is not alive, we should check if the next to last child (MIDX=2) is alive and living with the mother and so on.

I'm attaching the SPSS syntax and the output for table 11.3 (the % using bottle with nipple is not included in this syntax).
These are the steps I follow to identify the last child alive and living with the mother:

a) I used the women data file (IR) identify the last child living with the mother
b) I create a small data file with the mother id variables + the flag variable
c) I merge the file in point b) with the children data file (KR).
d) Select children alive and age = 0-23 month
e) Create my variables and do table

Dear DHS team,
I am working on the 20152016 Malawi Demographic and Health Survey dataset using SPSS. I would like to estimate the percentage of women who received a postnatal check during the first 2 days after birth (among women aged 15-49 who gave birth in the 2 years before the survey).
I have selected (b19 < 24) to restrict my analysis to women who gave birth in the last two years before the survey but my results didn't match those that are in the 2015-2016 report. I found that 43.4% of women who gave birth in the last two years had a postnatal check during the first 2 days instead of 42.4% which is in the report. Is it that the figure in the report is not correct or my calculations are wrong?
Please also help me on how to manage missing values in this variable? I am trying to replicate the results on column 10 in the table 9.9 in the report.
Any suggestions will be greatly appreciated. Thank you

The information provided on this Web site is not official U.S. Government information and
does not represent the views or positions of the U.S. Agency for International Development or the U.S. Government.