The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Uttar Pradesh data analysis mismatch (mismatch in place of delivery table 44 in Uttar Pradesh state report)
Uttar Pradesh data analysis mismatch [message #18260] Tue, 22 October 2019 00:40 Go to next message
shweta13tomar is currently offline  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.


Re: Uttar Pradesh data analysis mismatch [message #18339 is a reply to message #18260] Tue, 12 November 2019 13:55 Go to previous messageGo to next message
lmallick is currently offline  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
Re: Uttar Pradesh data analysis mismatch [message #18340 is a reply to message #18339] Tue, 12 November 2019 14:04 Go to previous messageGo to next message
shweta13tomar is currently offline  shweta13tomar
Messages: 3
Registered: October 2019
Member
Dear Dr. Mallick,

Thank you for your response. This is really helpful.

Warmly,
Shweta Tomar
Re: Uttar Pradesh data analysis mismatch [message #18356 is a reply to message #18340] Sat, 16 November 2019 15:03 Go to previous message
lmallick is currently offline  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
Previous Topic: Uttar Pradesh mismatch in antenatal care provider table 37
Next Topic: Appending multiple waves of the NFHS annd PSU codes
Goto Forum:
  


Current Time: Fri Mar 29 03:35:17 Coordinated Universal Time 2024