The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Ethiopia » Calculating stillbirth using Ethiopia DHS 2000
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #9999 is a reply to message #9933] Wed, 15 June 2016 00:40 Go to previous messageGo to previous message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 789
Registered: January 2013
Senior Member
Your approach above is close, but not correct. The main problem is your reshape command. This assumes that the birth history and the non-live pregnancy history are in parallel, that is the first entry in the birth history and the first entry in the non-live pregnancy history are for the same event - they are not. The birth history and the non-live birth history are completely mutually exclusive. You need to extract all of the stillbirths from the non-live pregnancy history, and then add these to the birth history file before trying to calculate stillbirth estimates.

Below is code for extracting the still births from the non-live pregnancy history:
use "C:\Data\DHS_Stata\ETIR41FL.DTA" , clear

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
Following this, you need to rename s231ac_ to b3 and then append this file to the BR dataset to produce a file of births and non-live pregnancies.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Analysis on Exclusive breastfeeding (EBF) in Ethiopian DHS 2016
Next Topic: Computing Newborn Mortality rates
Goto Forum:
  


Current Time: Thu Apr 25 15:38:42 Coordinated Universal Time 2024