The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Malawi DHS 2015-2016 -
Malawi DHS 2015-2016 - [message #12911] Mon, 07 August 2017 00:29 Go to next message
onkoka is currently offline  onkoka
Messages: 8
Registered: December 2016
Location: Taipei
Member

Greetings,

Using the Malawi DHS 2015-2016 replicate table 12.10; use of IPTp by women during pregnancy, my number if below the final total from that table by 144 cases. Here is my spss syntax and I am using the IR file which I have been using for previous years datasets:


*// Weighting Variable

COMPUTE WGT=V005 / 1000000.
EXECUTE.

WEIGHT BY WGT.

*// AgeMonths

COMPUTE AgeMonths=V008 - B3$01.
EXECUTE.

DATASET COPY PreviousTwoYears.
DATASET ACTIVATE PreviousTwoYears.
FILTER OFF.
USE ALL.
SELECT IF (AgeMonths < 24).
EXECUTE.
DATASET ACTIVATE DataSet1.

DATASET ACTIVATE PreviousTwoYears.
FREQUENCIES VARIABLES=AgeMonths
/ORDER=ANALYSIS.

My frequency gives me 6549 as a total while the in table 12.10 the total is 6693.

Where I am wrong that I should get different totals for the % of women with a live birth in the two years preceding the survey?

Regards,
Re: Malawi DHS 2015-2016 - [message #13167 is a reply to message #12911] Sun, 01 October 2017 00:21 Go to previous messageGo to next message
Liz-DHS
Messages: 1115
Registered: February 2013
Senior Member
Dear User,
Do you still need assistance with this post?
Thank you!
Re: Malawi DHS 2015-2016 - [message #13174 is a reply to message #13167] Sun, 01 October 2017 01:15 Go to previous messageGo to next message
onkoka is currently offline  onkoka
Messages: 8
Registered: December 2016
Location: Taipei
Member

Yes..That will be helpful. Thanks
Re: Malawi DHS 2015-2016 - [message #13375 is a reply to message #13167] Mon, 30 October 2017 04:27 Go to previous messageGo to next message
onkoka is currently offline  onkoka
Messages: 8
Registered: December 2016
Location: Taipei
Member

Dear Liz

Is there any progress pertaining my inquiry on this?


Regards,
Re: Malawi DHS 2015-2016 - [message #13509 is a reply to message #13375] Fri, 10 November 2017 17:34 Go to previous message
Liz-DHS
Messages: 1115
Registered: February 2013
Senior Member
A response from malaria expert, Cameron Taylor:
Quote:

Dear User,
Great question! The reason you are slightly off in your calculation is because the Malawi DHS 2015-16 is one of the first countries to start including the day of birth into the age calculation of the child. You can read much more about the change in calculation of child's age in the link below.
https://dhsprogram.com/data/calculating-the-age-of-children. cfm

So instead of SELECT IF (AgeMonths < 24) you need to use SELECT IF (B19$1 < 24). I have included my code below
*// Weighting table.
COMPUTE rweight = V005 / 1000000.
WEIGHT BY rweight.

*// Selecting only the last child 0-23 months old.
SELECT IF ( B19$01 <24).

*// Percentage who took 2+ doses of SP/Fansidar and received at least one during an  ANC visit  .
IF ( M49A$1=1 & ML1$1>= 2 & ML1$1<= 97 & ML2$1 = 1) SPANC2 = 1.
VARIABLE LABELS SPANC2  "Percentage who took 2+ doses of SP/Fansidar and received at least one during an  ANC visit".

FREQ SPANC2.


Previous Topic: Ghana 2016
Next Topic: Malawi 2014 MIS HML32 data values 4 & 5
Goto Forum:
  


Current Time: Mon Dec 11 11:51:05 Eastern Standard Time 2017