The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Uttar Pradesh mismatch in antenatal care provider table 37 (mismatch in number of women who had live birth in past 5 years)
Uttar Pradesh mismatch in antenatal care provider table 37 [message #18259] Mon, 21 October 2019 17:42 Go to next message
shweta13tomar is currently offline  shweta13tomar
Messages: 3
Registered: October 2019
Member
Hi,

I am unable to replicate the analysis presented in table 37 in state report for Uttar Pradesh. The total number of women who had a live birth in 5 years preceding the survey is 28,619 in the report but my analysis shows 28621. Please help.
Re: Uttar Pradesh mismatch in antenatal care provider table 37 [message #18338 is a reply to message #18259] Tue, 12 November 2019 13:26 Go to previous message
lmallick is currently offline  lmallick
Messages: 22
Registered: June 2019
Member
Dear user,

The denominator as listed in table 37 is 28,619; however, unlike standard DHS tabulations, this has excluded one case with missing information.

Please 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

As you will find in the GitHub repository, to recreate the table using the IR file, please try the following code:

//ANC by type of provider
gen rh_anc_pv = 6 if m2a_1! = .
replace rh_anc_pv = 4 if m2f_1 == 1 | m2g_1 == 1 | m2h_1 == 1 | m2i_1 == 1 | m2j_1 == 1 | m2k_1 == 1 | m2l_1 == 1 | m2m_1 == 1
replace rh_anc_pv = 3 if m2c_1 == 1 | m2d_1 == 1 | m2e_1 == 1
replace rh_anc_pv = 2 if m2b_1 == 1
replace rh_anc_pv = 1 if m2a_1 == 1
replace rh_anc_pv = 5 if m2a_1 == 9

label define rh_anc_pv ///
1 "Doctor" ///
2 "Nurse/midwife" ///
3 "Other health worker" ///
4 "TBA/other/relative" ///
5 "Missing" ///
6 "No ANC"
label val rh_anc_pv rh_anc_pv
label var rh_anc_pv "Person providing assistance during ANC"

tab rh_anc_pv [iw=sv005/1000000], m

//ANC by skilled provider
** Note: Please check the final report for this indicator to determine what provider is considered skilled.
recode rh_anc_pv (1/3 = 1 "Skilled provider") (4/6 = 0 "Unskilled/no one") , gen(rh_anc_pvskill)
label var rh_anc_pvskill "Skilled assistance during ANC"

tab rh_anc_pvskill [iw=sv005/1000000], m


Thank you,
Lindsay Mallick

Previous Topic: Nutritional status of women
Next Topic: Uttar Pradesh data analysis mismatch
Goto Forum:
  


Current Time: Wed Nov 27 02:34:23 Coordinated Universal Time 2024