Home » Topics » Mortality » Still Birth in India DHS-VII (Calculation of Still Birth Rates in India DHS-VII not matching with DHS report.)
| Still Birth in India DHS-VII [message #27693] |
Wed, 20 September 2023 15:46  |
Mohammad9981
Messages: 3
Registered: September 2023
|
Member |
|
|
Hello there!
I was calculating the stillbirth rate for the India DHS-VII (2019-21) using the Individual Recode file (IAIR7EFL.DTA). I used the following code for the calculation :
*create weight
gen wt=v005/1000000
*limit the calendar to 60 months before the interview
gen cal = substr(vcal_7, v018, 80)
*check length - this shows calendar has been cut to 60 months (5 years)
gen length = strlen(cal)
*find the last occurrence of each code B=birth, A=abortion, M=miscarriage, S=stillbirth
gen last = .
gen lastb = strpos(cal, "B")
gen lasta = strpos(cal, "A")
gen lastm = strpos(cal, "M")
gen lasts = strpos(cal, "S")
*replace the codes for whichever occurs first in the string (last = most recent in history)
replace last = lastb if (lastb > 0 & lastb < last)
replace last = lasta if (lasta > 0 & lasta < last)
replace last = lastm if (lastm > 0 & lastm < last)
replace last = lasts if (lasts > 0 & lasts < last)
*label the codes with numbers
gen lastcode = substr(cal, last, 1)
gen pregout = .
replace pregout = 1 if strmatch(lastcode,"B")
replace pregout = 2 if strmatch(lastcode,"A")
replace pregout = 3 if strmatch(lastcode,"M")
replace pregout = 4 if strmatch(lastcode,"S")
label var pregout "Last Pregnancy Outcome"
label define pregout 1 "live birth" 2 "abortion" 3 "miscarriage" 4 "stillbirth"
label values pregout pregout
tab pregout [iw=wt]
When i run this code i get an estimate of stillbirths but the value I am getting in the pregout variables are not matching with the DHS final report for the lastest India DHS-VII 2019-21. The report says the estimate of stillbirth is 0.9% and after my calculation using the code above the estimates comes to be 0.68%. Also on my calculation the total number of cases come to be 185445 and in the report the total cases are mentioned as 255,549 for all the pregnancy outcomes.
Kindly help!
Regards,
Mohammad
Kindly help me on what i am doing wrong such that my calculations are not matching with the DHS final report for India
|
|
|
|
Current Time: Mon Nov 25 17:27:34 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
