The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Fertility » Indonesia vcal calendar data
Re: Indonesia vcal calendar data [message #3648 is a reply to message #3557] Thu, 22 January 2015 11:20
 Trevor-DHS Messages: 680Registered: January 2013 Senior Member
I haven't gone through your code, but here is code that will calculate the number of still births from the calendar. It also calculates live births and total pregnancies of 7 months or more, but these counts exclude twins (for which you need to use the birth history in addition).

```* Calculate still births in the last 5 years
gen stillbirths = 0
gen births = 0
gen nlbirths = 0

* Set length of calendar to use
gen callen = v018 + 59
* If calendar is aligned right (as in original dataset), use the following:
gen beg = v018
gen end = callen
* If calendar is aligned left (as it appears to be), use the following:
*gen beg = 1
*gen end = 60

* Loop through calendar summing births, non-live pregnancies and stillbirths
forvalues i = 1/80 {
*   Restrict to 60 months preceding survey
replace births = births+1 if `i' >= beg & `i' <= end & substr(vcal_1,`i',1) == "B"
replace nlbirths = nlbirths+1 if `i' >= beg & `i' <= end & substr(vcal_1,`i',1) == "T"
replace stillbirths = stillbirths+1 if `i' >= beg & `i' <= end & substr(vcal_1,`i',7) == "TPPPPPP"
}

* total pregnancies in last 5 years
gen totpreg5 = births+nlbirths
* total pregnancies of 7+ months in last 5 years (all live births, plus the stillbirths)
gen totpreg7m = births+stillbirths

* Create weight variable.
gen wgt = v005/1000000

* Set up svyset parameters for complex samples.
svyset v021 [pweight=wgt], strata(v023)

* Produce number of stillbirths
svy: tab stillbirths, cell count```

 Indonesia vcal calendar data By: adev on Wed, 07 January 2015 14:08 Re: Indonesia vcal calendar data By: Trevor-DHS on Thu, 08 January 2015 10:45 Re: Indonesia vcal calendar data By: adev on Mon, 12 January 2015 05:08 Re: Indonesia vcal calendar data By: adev on Thu, 22 January 2015 09:07 Re: Indonesia vcal calendar data By: Trevor-DHS on Thu, 22 January 2015 11:20 Re: Indonesia vcal calendar data By: adev on Sat, 24 January 2015 11:39 Re: Indonesia vcal calendar data By: Liz-DHS on Wed, 28 January 2015 11:42 Re: Indonesia vcal calendar data By: adev on Mon, 02 February 2015 16:12 Re: Indonesia vcal calendar data By: tege2004@gmail.com on Mon, 12 December 2016 01:15 Re: Indonesia vcal calendar data By: Liz-DHS on Thu, 02 February 2017 14:07 Re: Indonesia vcal calendar data By: zelalemth on Mon, 07 October 2019 18:48 Re: Indonesia vcal calendar data By: Trevor-DHS on Tue, 08 October 2019 09:48 Re: Indonesia vcal calendar data By: Mark on Tue, 07 January 2020 01:36 Re: Indonesia vcal calendar data By: Liz-DHS on Tue, 07 January 2020 09:17 Re: Indonesia vcal calendar data By: Mark on Thu, 09 January 2020 05:32 Re: Indonesia vcal calendar data By: Trevor-DHS on Mon, 02 February 2015 16:58 Re: Indonesia vcal calendar data By: adev on Wed, 04 February 2015 07:48 Re: Indonesia vcal calendar data By: Trevor-DHS on Wed, 04 February 2015 08:14 Re: Indonesia vcal calendar data By: adev on Fri, 20 February 2015 05:25 Re: Indonesia vcal calendar data By: Trevor-DHS on Fri, 20 February 2015 10:12 Re: Indonesia vcal calendar data By: plnep on Tue, 27 October 2015 02:20 Re: Indonesia vcal calendar data By: Trevor-DHS on Tue, 24 November 2015 19:23
 Previous Topic: B11 is actually missing or it represent first birth? Next Topic: last birth
Goto Forum:

Current Time: Tue Mar 31 16:00:19 Eastern Daylight Time 2020