The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Ethiopia » Replicating table 8.4: ETHIOPIA DHS 2000 (Calculating perinatal mortality using the ETHIOPIA DHS 2000 data)
Replicating table 8.4: ETHIOPIA DHS 2000 [message #20271] Sun, 18 October 2020 09:28 Go to next message
Melese is currently offline  Melese
Messages: 8
Registered: August 2019
Member
Dear Expert, greetings. I tried to replicate table 8.4 "Perinatal mortality rate" using the 2000 Ethiopia DHS. "vcal_1" doesn't exist the ETHIOPIA 2000 DHS data. Can anyone help with the STATA SYNTAX to calculate perinatal mortality rate using the ETHIOPIA 2000 data in the same way as mentioned in the GitHub: "https://github.com/DHSProgram/DHS-Indicators-Stata" " https://github.com/DHSProgram/DHS-Indicators-Stata/tree/mast er/Chap08_CM"?
Regards
Melese
Re: Replicating table 8.4: ETHIOPIA DHS 2000 [message #20297 is a reply to message #20271] Tue, 20 October 2020 15:53 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2025
Registered: February 2013
Senior Member
Please see the following guidance from DHS Senior Technical Director: Trevor Croft:

See https://userforum.dhsprogram.com/index.php?t=msg&th=5153 &goto=9859&#msg_9859 for an existing discussion.

This also refers to https://userforum.dhsprogram.com/index.php?t=msg&th=4692 &goto=8657&#msg_8657 which provides code for Nepal, but the principle is the same for Ethiopia 2000.

See also the attached snippet of code.

Note that we don't have vcal_1, but we have a pregnancy history, so can get the same information out of the pregnancy history.

[Updated on: Mon, 26 October 2020 08:22]

Report message to a moderator

Re: Replicating table 8.4: ETHIOPIA DHS 2000 [message #20342 is a reply to message #20297] Sun, 25 October 2020 09:10 Go to previous message
Melese is currently offline  Melese
Messages: 8
Registered: August 2019
Member
Hi Bridgette, greetings again and thank you for the reply. Unfortunately, I couldn't still generate the table 8.4: for EDHS 2000 which I easily did using EDHS 2005 and above data. I followed the discussions and failed to have the appropraite syntax. I used the following syntax with EDHS 2000 IR data file.

"keep caseid v001 v002 v003 v005 v008 v011 v013 v017 v018 v019 v021 v022 v023 v* s231ac_* s231c_*
rename *_0* *_*
reshape long s231ac_ s231c_, i(caseid) j(i)
drop if s231ac_==.
keep if s231ac_ > v008-60 & s231c>=7
rename s231ac_ b3"

merging with BR file using v001 v002 v003 creates error.

Can you help with fixing the merging and syntax for generating the variables "stillbirths", "early neonatal mortality", ang "perinatal mortality",please?
Kindest regards
Melese
Previous Topic: Ethiopia DHS 2016: Table 11.7
Next Topic: Request for clarification
Goto Forum:
  


Current Time: Wed Nov 25 17:26:27 Coordinated Universal Time 2020