The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nepal » Replicating table 9.10 of Nepal DHS 2016
Replicating table 9.10 of Nepal DHS 2016 Sat, 19 September 2020 16:12
 Mohan Messages: 2Registered: September 2020 Member
Hi,
I am trying to replicate the table 9.10 of Nepal Demographic health survey 2016 Report in STATA but my result are slightly different then the published one. The percentage distribution of cesarean section with age group <20, 20-35, 35-49 is slightly different. The Total Number of cesarean section number I got is 5107 but in the report it is 5060.

Thank you.
Re: Replicating table 9.10 of Nepal DHS 2016 [message #20042 is a reply to message #20031] Mon, 21 September 2020 14:33
 Shireen-DHS Messages: 45Registered: August 2020 Location: USA Member
Dear Mohan,

The following code below will give you a match with the final report.

Also for the future, please check the DHS code share site on GitHub that contains code for all DHS indicators listed in the Guide to DHS Statistics. https://github.com/DHSProgram/DHS-Indicators-Stata

Thank you.
Best,
Shireen
The DHS Program

Stata code for your C-section in 2016 DHS Nepal survey:

gen age=b19
*define period as birth in the last five years
gen period = 60

*Caesarean delivery
gen rh_del_ces = 0
replace rh_del_ces = 1 if m17==1
replace rh_del_ces = . if age>=period
label define rh_del_ceslab 0 "No" 1 "Yes"
label val rh_del_ces rh_del_ceslab
label var rh_del_ces "Live births delivered by Caesarean"

* mother's age at birth (years): <20, 20-29, 30-39, 40-49
gen months_age=b3-v011
gen mageb=1 if months_age<20*12
replace mageb=2 if months_age>=20*12 & months_age<35*12
replace mageb=3 if months_age>=35*12
label define mageb 1"<20" 2"20-24" 3"35-49"
label values mageb mageb

gen wt=v005/1000000

*this matches Table 9.10 of the Final report
tab mageb rh_del_ces [iw=wt], row
Re: Replicating table 9.10 of Nepal DHS 2016 [message #20046 is a reply to message #20042] Tue, 22 September 2020 04:07
 Mohan Messages: 2Registered: September 2020 Member
Dear Shireen, Thank you very much. I have accessed the stata code but i haven't find the code for mother age. Actually I have converted the age in years instead in month. Now it worked. Thank you.
Re: Replicating table 9.10 of Nepal DHS 2016 [message #20049 is a reply to message #20042] Tue, 22 September 2020 05:55
 rishabh21 Messages: 7Registered: September 2019 Member
Dear Shireen,
I tried many times in NFHS-4, India but stillbirths disaggregate by previous pregnancy birth interval in months? [NFHS-4 report: Table no 7.5]