The DHS Program User Forum: Dataset use in Stata » DHS 2010 Malawi Report Replication

Home » Data » Dataset use in Stata » DHS 2010 Malawi Report Replication

Show: Today's Messages :: Show Polls :: Message Navigator

DHS 2010 Malawi Report Replication [message #13346]

Thu, 26 October 2017 09:53

jrg20
Messages: 4
Registered: October 2017
Location: South Africa

Member

Hello,

I am attempting to replicate Table 2.4 from the Malawi 2010 DHS Report.
Find my (stata) code below:

gen weight=hv005/1000000
svyset [pw=weight], psu(hv021) strata(hv022)

svy:tab hv122 if inrange(hv105,6,13) & hv025==1 & hv104==1 & hv103==1 /// range given in the notes in DHS Final report Table 2.4 where hv103==1 is defacto, hv025==1 is urban, and hv104==1 is male.

Output from this code is giving me that ratio attended =92.76% instead of 96.3% as reported in the DHS Report.
May you kindly tell me where I am getting this wrong?

Thank you.

Report message to a moderator

Re: DHS 2010 Malawi Report Replication [message #13355 is a reply to message #13346]

Fri, 27 October 2017 07:09

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is a response from DHS Senior Research Associate, Shireen Assaf:

The footnote in the table indicates that it is for age 6-13 years but it's actually for 7-12 years, according to the CSPro code on file. You can match the table with this command:

svy:tab hv122 if inrange(hv105,7,12) & hv025==1 & hv104==1 & hv103==1

The age range for primary school varies slightly from one country to another. We will notify the appropriate staff of this error in the footnote. Thank you for catching it.

Report message to a moderator

Re: DHS 2010 Malawi Report Replication [message #13356 is a reply to message #13355]

Fri, 27 October 2017 07:31

jrg20
Messages: 4
Registered: October 2017
Location: South Africa

Member

Thank you for that clarification. However, the official school starting age in Malawi is actually six years not seven, so the footnote was actually correct though the coding was not. Thank you so much.

Report message to a moderator

Re: DHS 2010 Malawi Report Replication [message #13357 is a reply to message #13356]

Fri, 27 October 2017 07:59

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Thanks for alerting us to this. We will discuss the best way to make a correction. In any case, you now know why you were not matching the table.

Tom Pullum

Report message to a moderator

Previous Topic:	Opening DHS data on STATA 13
Next Topic:	Merging and appending Kenya DHS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jan 30 22:18:17 Coordinated Universal Time 2025