The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Countries » Ethiopia » Calculating stillbirth using Ethiopia DHS 2000
Calculating stillbirth using Ethiopia DHS 2000 [message #9859] Wed, 01 June 2016 07:07 Go to next message
Sami is currently offline  Sami
Messages: 16
Registered: May 2016
Location: Nepal
Member
Dear DHS forum,

I was trying to calculate total number of stillbirth five years preceding the survey using Ethiopia DHS 2000 individual recode data file. I could not find calander, pregnancy history and pregnancy outcome variables in this data file. Can anyone help me what variables I should be working with to calculate stillbirths for Ethiopia 2000 DHS?

Thank you heaps

Sammy
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #9896 is a reply to message #9859] Fri, 03 June 2016 16:10 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 566
Registered: January 2013
Senior Member
The stillbirth information can be found by using the duration of pregnancies from the calendar. The calendar data is in vcal_1. Please see the example code already on the forum.
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #9915 is a reply to message #9896] Mon, 06 June 2016 10:15 Go to previous messageGo to next message
Sami is currently offline  Sami
Messages: 16
Registered: May 2016
Location: Nepal
Member

Dear Trevor,

Thank you so much for your reply. However, Ethiopia DHS 2011 has no calendar information (Vcal_1), neither it has variable of pregnancy outcome (Live born/ Born dead/ lost before pregnancy). EDHS 2000 IR data file has no variable such as pregnancy history. I used the code you gave me but it did not work with EDHS 2000 IR data file. In this situation, how can i calculate stillbirth using EDHS 2011 IR data file.

Yours sincerely
Sammy
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #9917 is a reply to message #9915] Mon, 06 June 2016 10:20 Go to previous messageGo to next message
Sami is currently offline  Sami
Messages: 16
Registered: May 2016
Location: Nepal
Member
Sorry, i made mistake.

i was using EDHS 2000 not 2011. I actually calculated the stillbirth for EDHS 2005 and 2011.

I just need the help to calculate stillbirth using EDHS 2000.

Thank you so much.

Yours sincerely

Sammy
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #9927 is a reply to message #9917] Mon, 06 June 2016 17:20 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 566
Registered: January 2013
Senior Member
Sorry, the example given before was for a survey with a calendar, but Ethiopia 2000 does not have a calendar.

Instead, you may want to look at the example code in the linked message. This code refers to Nepal 2001 data, but the concept is very similar. The EDHS 2000 uses a pregnancy history, and the pregnancy history variables needed can be found in the variables S231AC*, and S231C*.
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #9933 is a reply to message #9927] Mon, 06 June 2016 22:19 Go to previous messageGo to next message
Sami is currently offline  Sami
Messages: 16
Registered: May 2016
Location: Nepal
Member
Dear Trevor,

Thank you so much for getting back to me.

I used the code you gave me which was used for Nepal DHS 2001 data file.

I have couple of issues here:

1. EDHS 2000 do not have variable such as s216 which was used to calculate stillbirth for 2001 Nepal DHS.
2. After reshaping, i used idx92_==. to drop empty entries that contain no data but it gives me total number of live births in five years preceding the survey rather than total number of pregnancies five years proceeding the survey.

I would like to share the code i used which was initially made by you for Nepal DHS 2001. Unfortunately it did not work.

Can you please advise what wrong did i do to calculate stillbirth using EDHS 2000 IR data file?

use "C:\Data\DHS_Stata\ETIR41FL.DTA" , clear


keep caseid v001 v002 v003 v005 v008 v011 v013 v017 v018 v019 v021 v022 v023 s231c_* s231ac_* g231ac_* bidx_* bord_* idx92_* idx94_* v* b0_* b1_* b2_* b3_* b4_* b5_* b6_* b7_* b8_* b9_* b10_* b11_* b12_* b13_* b15_* b16_* scol24_* s230amg s230ayg s231ac_* g231am_* s231am_*

rename *_0* *_*

reshape long idx92_ idx94_ bord_ bidx_ b0_ b1_ b2_ b3_ b4_ b5_ b6_ b7_ b8_ b9_ b10_ b11_ b12_ b13_ b15_ b16_ s231ac_ s231c_ g231ac_ scol24_ g231am_ s231am_, i(caseid) j(i)

drop if idx92_==.


rename idx92_ idx
rename s*_ s*
rename b* p*

keep if p3 > v008-60|s231ac> v008-60


keep if s231c==.|s231c>=7
tab type [iw=v005/1000000]

Thank you so much.

Yours sincerely

Sammy


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 next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 566
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.
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #10085 is a reply to message #9999] Fri, 24 June 2016 02:13 Go to previous messageGo to next message
Sami is currently offline  Sami
Messages: 16
Registered: May 2016
Location: Nepal
Member

Dear Trevor,

Thank you so much for the support.

Regards

Sammy
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #10620 is a reply to message #9927] Thu, 18 August 2016 21:41 Go to previous messageGo to next message
Sami is currently offline  Sami
Messages: 16
Registered: May 2016
Location: Nepal
Member
Dear Trevor,

I hope you are doing well.

I was trying to calculate stillbirth using Pakistan DHS 2012-13. This time i was trying not to use calendar. Instead of calendar, i intend to use pregnancy history information but my number does not match the number. Can you please advise me if i am using the right code. The code i used was:

use "PKIR61FL.DTA", clear

keep caseid v001 v002 v003 v005 v008 v011 v012 v013 v021 v022 v023 v024 v025 v201 v208 v211 v212 v218 v222 v224 v225 v228 v229 v230 v231 v232 v233 v234 v235 v239 v240 v241 v242 idx97_* ord97_* s2*_* midx_* m2n_* m13_* m14_* s* b*

rename *_0* *_*

reshape long bidx_ bord_ b0_ b1_ b2_ b3_ b4_ b5_ b6_ b7_ b8_ b9_ b10_ b11_ b12_ b13_ b15_ b16_ idx97_ ord97_ s215_ s216_ s217_ s219_ s220m_ s220y_ s220c_ s220f_ s225c_ s225f_ midx_ m2n_ m13_ m14_ s221_ s222_ s223_ s224_ s225u_ s225n_ s226m_ s226y_ s227_ s228_ s229_, i(caseid) j(idx)
count
drop if idx97_==.
count
rename s*_ s*
rename b* p*
keep if s220c > v008-60
tab s227 s216 [iw=v005/1000000],m
keep if s227 == . | s227 >= 7
recode s216 (1=1 "Live birth")(2/3=2 "Stillbirth"), gen(type)
tab type
tab type [iw=v005/1000000]


Thank you so much for your time.

Sammy

Re: Calculating stillbirth using Ethiopia DHS 2000 [message #10623 is a reply to message #10620] Fri, 19 August 2016 17:33 Go to previous messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 566
Registered: January 2013
Senior Member
A few problems with the code you provided. You cannot mix the b* variables with the s2* variables and the m* variables. The b* and m* variables are for births and bidx_01 and midx_1 are the same birth, so you can use these together in a reshape command. However, the s2*, idx97* and ord97* variables are for pregnancies, not births and so idx97_01 and bidx_01 are not necessarily the same pregnancy/birth.

For the stillbirths, you don't need the b* and m* variables.

Here is a revised piece of code:
use "PKIR61FL.DTA", clear 

keep caseid v001 v002 v003 v005 v008 v011 v012 v013 v021 v022 v023 v024 v025 v201 v208 v211 v212 v218 v222 v224 v225 v228 v229 v230 v231 v232 v233 v234 v235 v239 v240 v241 v242 idx97_* ord97_* s2*_* 

rename *_0* *_*

local varlist idx97_ ord97_ s215_ s216_ s217_ s219_ s220m_ s220y_ s220c_ s220f_ s225c_ s225f_ s221_ s222_ s223_ s224_ s225u_ s225n_ s226m_ s226y_ s227_ s228_ s229_

* capture the variable labels
foreach v of local varlist { 
di "`v'"
	local l`v' : variable label `v'1
} 

reshape long `varlist', i(caseid) j(idx)

* copy the variable labels back to the variables
foreach v of local varlist {
  label variable `v' `"`l`v''"'
}

rename s*_ s*
rename idx97_ idx97
rename ord97_ ord97

drop if idx97==. 

keep if v008-s220c < 60

gen type = .
replace type = 1 if s216==1 | s217==1
replace type = 2 if type==. & s227 >= 7 & s227 < 98 
replace type = 3 if type==. & (s227 < 7 | s227 >= 98) & s228 == 1
replace type = 4 if type==. & (s227 < 7 | s227 >= 98)
lab def type 1 "Live birth" 2 "Stillbirth" 3 "Abortion" 4 "Miscarriage"
lab val type type
lab var type "Type of pregnancy"

tab type [iw=v005/1000000] 

I also added code above to carry the variable labels over from before the reshape to the new variables after the reshape.
This code produces slightly more stillbirths than in the DHS report as the DHS report calculates stillbirths from the calendar where a stillbirth at the time of live birth is not included, and where twin stillbirths are only counted once. Thus this code is producing about 12 extra stillbirths than the code based on the calendar, and similarly the total pregnancies of 7 months or more is high by the same number.
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #10629 is a reply to message #10623] Mon, 22 August 2016 06:54 Go to previous messageGo to next message
Sami is currently offline  Sami
Messages: 16
Registered: May 2016
Location: Nepal
Member
Dear Trevor,

Your help is so much appreciable.

Sammy
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #10848 is a reply to message #10623] Sat, 24 September 2016 02:23 Go to previous messageGo to next message
chr8850
Messages: 15
Registered: July 2016
Member
Hi Trevor,

I am doing a similar analysis with Pakistan DHS data using pretty much the same code you posted and wondered about your statement on mixing the b* m* and s* variables. Is it ok to include some of the m* (with the idx and s variables) variables in the reshape in order to look at the maternity care variables for the live and non-live births?

Regards
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #10853 is a reply to message #10848] Sun, 25 September 2016 08:36 Go to previous messageGo to next message
chr8850
Messages: 15
Registered: July 2016
Member
Also just in addition to the same dataset I have a query about the index variables idx97, idx, and midx. When i look at the last live birth for each mother and tabulate that by restricting to idx==1 (or idx97 gives the same number) i get 10,476 births, but when i look at the data when midx==1 there is data for only 6,892 and the remainder appears to be missing/not applicable. Does this mean that not all of the mothers last births are included in the maternity care section? I'm just trying to understand why the data is not collected for all of the 10,476 births or if I have done something incorrectly.
Re: Calculating stillbirth using Ethiopia DHS 2000 [message #11687 is a reply to message #9927] Mon, 30 January 2017 05:38 Go to previous message
Sami is currently offline  Sami
Messages: 16
Registered: May 2016
Location: Nepal
Member
Dear Sir,

I was trying to calculate total number of stillbirth using Nepal DHS dada 2011 (NPIR60FL.dta) using pregnancy history information. I used similar approach you previously used for Nepal DHS 2001. But my number does not match the number as appeared as 53 stillbirth and 5444 total pregnancy 7+ month' gestation. Here is the code I used to calculate stillbirth.


use "C:NPIR60FL.DTA"

keep caseid v214 v219 v220 v223 v225 v228 v229 v230 v231 v233 v001 v002 v003 v005 v008 v011 v013 ///
v017 v018 v019 v021 v022 v023 pidx97_* bord92_* pord97_* bidx97_* b0_* b1_* b2_* b3_* b4_* b5_* b6_* ///
b7_* b8_* b9_* b10_* b11_* b12_* b13_* b15_* b16_* s216_* s216b_* s217_* s228_* s220ab_* s220a_* ///
s220c_* sprego_* s226m_* s227_* s226c_* s229_* vcal_* m1_* m4_* m10_* m13_* m14_* m15_* m17_* m18_* ///
m46_* m45_* m34_* m3a_* m3b_* m3c_* m3d_* m3e_* m3f_* m3g_* m3h_* m3i_* m3j_* m3k_* m3l_* m3m_* m3n_* ///
v102 v168 v012 v502 v155 v463a v463b v463e v463f v463g v463x v024 sdevreg v212 v364 v206 v207 v717 v731 ///
v106 v705 v729 v130 v113 v116 v161 v158 v157 v159 v113 v116 v119 v120 v121 v123 v127 v153 v190 caseid v001 ///
v002 v003 v005 v008 v011 v013 v017 v018 v019 v021 v022 v023 v024 v*
rename *_0* *_*
reshape long pidx97_ pord97_ bord92_ bidx97_ b0_ b1_ b2_ b3_ b4_ b5_ b6_ b7_ b8_ b9_ b10_ b11_ b12_ b13_ b15_ ///
b16_ s216_ s216b_ s217_ s226m_ s227_ s228_ sprego_ s220ab_ s220a_ s226c_ s220c_ s229_ vcal_ m1_ m4_ m10_ m13_ ///
m14_ m15_ m17_ m18_ m46_ m45_ m34_ m3a_ m3b_ m3c_ m3d_ m3e_ m3f_ m3g_ m3h_ m3i_ m3j_ m3k_ m3l_ m3m_ m3n_, i(caseid) j(p)
count
drop if pidx97_==.
count
rename pidx97_ pidx
rename bord92_ bord
rename bidx97_ bidx
rename s*_ s*
rename b*_ p*
rename vcal_ vcal


keep if (v008-p3)<=59| (v008-s226c)<=59

tab s220ab s216 [iw=v005/1000000],m

replace s216=1 if s220ab==. & s216==2

replace s216=3 if s220ab==3 & s216==2

keep if s220ab == . | s220ab >= 7
recode s216 (1=1 "Live birth")(2/3=2 "Stillbirth"), gen(type)
tab type
tab type [iw=v005/1000000]


Can you please advise me what wrong did I do in the above command? because I do not want to use calendar information to calculate stillbirth. (I would like to apply similar approach you used to calculate stillbirth for 2001 Nepal dhs data)

Thank you so much.

Warm regards

Sammy

Previous Topic: Breastfeeding Initiation in Ethiopian population
Next Topic: About release of 2016 Ethiopian DHS
Goto Forum:
  


Current Time: Sun Apr 22 06:29:07 Eastern Daylight Time 2018