The graduation by semester variables (grad_sem02 - grad_sem20) are created in Stata using the following syntax:
foreach N in 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 {
gen grad_sem`N'= 0
}
replace grad_sem02 = 1
if (time_to_grad_cert > 100 & time_to_grad_cert < 300)
| (time_to_grad_aa > 100 & time_to_grad_aa < 300)
| (time_to_grad_ba > 100 & time_to_grad_ba < 300)
replace grad_sem03 = 1
if (time_to_grad_cert > 300 & time_to_grad_cert < 500)
| (time_to_grad_aa > 300 & time_to_grad_aa < 500)
| (time_to_grad_ba > 300 & time_to_grad_ba < 500)
replace grad_sem04 = 1
if (time_to_grad_cert > 500 & time_to_grad_cert < 700)
| (time_to_grad_aa > 500 & time_to_grad_aa < 700)
| (time_to_grad_ba > 500 & time_to_grad_ba < 700)
replace grad_sem05 = 1
if (time_to_grad_cert > 700 & time_to_grad_cert < 875)
| (time_to_grad_aa > 700 & time_to_grad_aa < 875)
| (time_to_grad_ba > 700 & time_to_grad_ba < 875)
replace grad_sem06 = 1
if (time_to_grad_cert > 875 & time_to_grad_cert < 1050)
| (time_to_grad_aa > 875 & time_to_grad_aa < 1050)
| (time_to_grad_ba > 875 & time_to_grad_ba < 1050)
replace grad_sem07 = 1
if (time_to_grad_cert > 1050 & time_to_grad_cert < 1225)
| (time_to_grad_aa > 1050 & time_to_grad_aa < 1225)
| (time_to_grad_ba > 1050 & time_to_grad_ba < 1225)
replace grad_sem08 = 1
if (time_to_grad_cert > 1225 & time_to_grad_cert < 1400)
| (time_to_grad_aa > 1225 & time_to_grad_aa < 1400)
| (time_to_grad_ba > 1225 & time_to_grad_ba < 1400)
replace grad_sem09 = 1
if (time_to_grad_cert > 1400 & time_to_grad_cert < 1600)
| (time_to_grad_aa > 1400 & time_to_grad_aa < 1600)
| (time_to_grad_ba > 1400 & time_to_grad_ba < 1600)
replace grad_sem10 = 1
if (time_to_grad_cert > 1600 & time_to_grad_cert < 1800)
| (time_to_grad_aa > 1600 & time_to_grad_aa < 1800)
| (time_to_grad_ba > 1600 & time_to_grad_ba < 1800)
replace grad_sem11 = 1
if (time_to_grad_cert > 1800 & time_to_grad_cert < 1950)
| (time_to_grad_aa > 1800 & time_to_grad_aa < 1950)
| (time_to_grad_ba > 1800 & time_to_grad_ba < 1950)
replace grad_sem12 = 1
if (time_to_grad_cert > 1950 & time_to_grad_cert < 2150)
| (time_to_grad_aa > 1950 & time_to_grad_aa < 2150)
| (time_to_grad_ba > 1950 & time_to_grad_ba < 2150)
replace grad_sem13 = 1
if (time_to_grad_cert > 2150 & time_to_grad_cert < 2325)
| (time_to_grad_aa > 2150 & time_to_grad_aa < 2325)
| (time_to_grad_ba > 2150 & time_to_grad_ba < 2325)
replace grad_sem14 = 1
if (time_to_grad_cert > 2325 & time_to_grad_cert < 2500)
| (time_to_grad_aa > 2325 & time_to_grad_aa < 2500)
| (time_to_grad_ba > 2325 & time_to_grad_ba < 2500)
replace grad_sem15 = 1
if (time_to_grad_cert > 2500 & time_to_grad_cert < 2700)
| (time_to_grad_aa > 2500 & time_to_grad_aa < 2700)
| (time_to_grad_ba > 2500 & time_to_grad_ba < 2700)
replace grad_sem16 = 1
if (time_to_grad_cert > 2700 & time_to_grad_cert < 2900)
| (time_to_grad_aa > 2700 & time_to_grad_aa < 2900)
| (time_to_grad_ba > 2700 & time_to_grad_ba < 2900)
replace grad_sem17 = 1
if (time_to_grad_cert > 2900 & time_to_grad_cert < 3050)
| (time_to_grad_aa > 2900 & time_to_grad_aa < 3050)
| (time_to_grad_ba > 2900 & time_to_grad_ba < 3050)
replace grad_sem18 = 1
if (time_to_grad_cert > 3050 & time_to_grad_cert < 3200)
| (time_to_grad_aa > 3050 & time_to_grad_aa < 3200)
| (time_to_grad_ba > 3050 & time_to_grad_ba < 3200)
replace grad_sem19 = 1
if (time_to_grad_cert > 3200 & time_to_grad_cert < 3425)
| (time_to_grad_aa > 3200 & time_to_grad_aa < 3425)
| (time_to_grad_ba > 3200 & time_to_grad_ba < 3425)
replace grad_sem20 = 1
if (time_to_grad_cert > 3425 & time_to_grad_cert < 3600)
| (time_to_grad_aa > 3425 & time_to_grad_aa < 3600)
| (time_to_grad_ba > 3425 & time_to_grad_ba < 3600)
The cutoffs in the code above were determined by the range of days between entry and degree completion for a given semester. The following table presents the actual range and the cutoffs determined by them.
Semester
|
Actual Range
|
Cutoffs
|
2
|
153-274
|
(100-300)
|
3
|
365-486
|
(300-500)
|
4
|
518-639
|
(500-700)
|
5
|
730-851
|
(700-875)
|
6
|
883-1004
|
(875-1050)
|
7
|
1095-1216
|
(1050-1225)
|
8
|
1248-1361
|
(1225-1400)
|
9
|
1461-1582
|
(1400-1600)
|
10
|
1614-1735
|
(1600-1800)
|
11
|
1826-1944
|
(1800-1950)
|
12
|
1979-2100
|
(1950-2150)
|
13
|
2191-2312
|
(2150-2325)
|
14
|
2344-2465
|
(2325-2500)
|
15
|
2556-2677
|
(2500-2700)
|
16
|
2709-2830
|
(2700-2900)
|
17
|
2922-3043
|
(2900-3050)
|
18
|
3075-3196
|
(3050-3200)
|
19
|
3287-3408
|
(3200-3425)
|
20
|
3440-3561
|
(3425-3600)
|