The DHS Program User Forum: India » Uttar Pradesh data analysis mismatch

Home » Countries » India » Uttar Pradesh data analysis mismatch (mismatch in place of delivery table 44 in Uttar Pradesh state report)

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

Uttar Pradesh data analysis mismatch [message #18260]

Tue, 22 October 2019 00:40

shweta13tomar
Messages: 3
Registered: October 2019

Member

Hi,

I am trying to calculate institutional delivery rate for Uttar Pradesh. tabulation of variable m15_1 is not matching with table 44 in the state report. My code and output along with table from state report is attached. please help.

Attachment: code and output.pdf
(Size: 151.92KB, Downloaded 374 times)

Report message to a moderator

Re: Uttar Pradesh data analysis mismatch [message #18339 is a reply to message #18260]

Tue, 12 November 2019 13:55

lmallick
Messages: 22
Registered: June 2019

Member

Dear user,

It appears that the code used to create this table assigned facility categories to incorrect designations. We are following up internally. Meanwhile, please try this code using the KR file:

keep if v024==33
gen swt = sv005/1000000
numlabel, add

recode m15 (11 = 4 "Own home") (12 = 5 "Other home") (13 = 6 "Parents' home") ///
(21/27 = 1 "Public Sector") (33 = 2 "NGO") (31/32 = 3 "Private") ///
(96 . =7 "Other") if bidx ==1, gen(facdel)

recode facdel (4 5 6 = 2 "Home") (1 2 3 = 1 "Facility") (7 = 3 "Other") if bidx==1, gen(facdel2)

tab facdel if bidx==1 [iw=swt]
tab facdel2 if bidx==1 [iw=swt]

Please also be aware of several publicly available resources we have, including tips on matching tables: https://blog.dhsprogram.com/final-report-tables/ , The DHS Guide to Statistics: https://dhsprogram.com/publications/publication-dhsg1-dhs-qu estionnaires-and-manuals.cfm , and Stata programs for most chapters on GitHub: https://github.com/DHSProgram/DHS-Indicators-Stata.

Thank you,
Lindsay Mallick

Report message to a moderator

Re: Uttar Pradesh data analysis mismatch [message #18340 is a reply to message #18339]

Tue, 12 November 2019 14:04

shweta13tomar
Messages: 3
Registered: October 2019

Member

Dear Dr. Mallick,

Thank you for your response. This is really helpful.

Warmly,
Shweta Tomar

Report message to a moderator

Re: Uttar Pradesh data analysis mismatch [message #18356 is a reply to message #18340]

Sat, 16 November 2019 15:03

lmallick
Messages: 22
Registered: June 2019

Member

Dear Dr. Tomar,

My sincerest apologies- it appears there is not an error in the code as I had originally thought. These reports differ from the typical DHS table structure and I missed the denominator specification. The denominator that we in fact need to match is all births. Therefore, please use the above code but take out "bidx==1" in all instances and try it again.

Thank you,
Lindsay

Report message to a moderator

Previous Topic:	Uttar Pradesh mismatch in antenatal care provider table 37
Next Topic:	Appending multiple waves of the NFHS annd PSU codes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 13:22:00 Coordinated Universal Time 2024