*Use with Hannon_DeFina.dta **generate newyear** gen newyear=year-78 if year<=94 replace newyear = 17 if year==96 replace newyear = 18 if year==98 *declare data to be a panel with newyear and CASEID* tsset CASEID newyear, yearly *generate race variable* gen white=0 if race!=. replace white = . if race <0 replace white=1 if race==1 gen black=0 if race!=. replace black = . if race <0 replace black=1 if race==2 gen other = 0 if race!=. replace other = . if race<0 replace other = 1 if race==3 *generate incar variable* gen incar = 0 replace incar =. if HH1_1y<0 replace incar=1 if HH1_1y==3 & newyear==1 replace incar=1 if HH1_1y==5 & newyear>1 *adjust incar variable to classify those interviewed at home as non-missing and non-incarcerated* gen incar2= 0 replace incar2=1 if incar==1 replace incar2=. if incar==. replace incar2=0 if HH1_1y==-4 *generate everincar* gen everincar = 0 replace everincar = 1 if newyear==1 & incar==1 replace everincar = 1 if (incar==1 & newyear==2) | (l.incar==1 & newyear==2) replace everincar = 1 if (incar==1 & newyear==3) | (l.incar==1 & newyear==3) | (l2.incar==1 & newyear == 3) replace everincar = 1 if (incar==1 & newyear==4) | (l.incar==1 & newyear==4) | (l2.incar==1 & newyear == 4) | (l3.incar==1 & newyear == 4) replace everincar = 1 if (incar==1 & newyear==5) | (l.incar==1 & newyear==5) | (l2.incar==1 & newyear == 5) | (l3.incar==1 & newyear == 5) | (l4.incar==1 & newyear == 5) replace everincar = 1 if (incar==1 & newyear==6) | (l.incar==1 & newyear==6) | (l2.incar==1 & newyear == 6) | (l3.incar==1 & newyear == 6) | (l4.incar==1 & newyear == 6) | (l5.incar==1 & newyear == 6) replace everincar = 1 if (incar==1 & newyear==7) | (l.incar==1 & newyear==7) | (l2.incar==1 & newyear == 7) | (l3.incar==1 & newyear == 7) | (l4.incar==1 & newyear == 7) | (l5.incar==1 & newyear == 7) | (l6.incar==1 & newyear == 7) replace everincar = 1 if (incar==1 & newyear==8) | (l.incar==1 & newyear==8) | (l2.incar==1 & newyear == 8) | (l3.incar==1 & newyear == 8) | (l4.incar==1 & newyear == 8) | (l5.incar==1 & newyear == 8) | (l6.incar==1 & newyear == 8) | (l7.incar==1 & newyear == 8) replace everincar = 1 if (incar==1 & newyear==9) | (l.incar==1 & newyear==9) | (l2.incar==1 & newyear == 9) | (l3.incar==1 & newyear == 9) | (l4.incar==1 & newyear == 9) | (l5.incar==1 & newyear == 9) | (l6.incar==1 & newyear == 9) | (l7.incar==1 & newyear == 9) | (l8.incar==1 & newyear == 9) replace everincar = 1 if (incar==1 & newyear==10) | (l.incar==1 & newyear==10) | (l2.incar==1 & newyear == 10) | (l3.incar==1 & newyear == 10) | (l4.incar==1 & newyear == 10) | (l5.incar==1 & newyear == 10) | (l6.incar==1 & newyear == 10) | (l7.incar==1 & newyear == 10) | (l8.incar==1 & newyear == 10) | (l9.incar==1 & newyear == 10) replace everincar = 1 if (incar==1 & newyear==11) | (l.incar==1 & newyear==11) | (l2.incar==1 & newyear == 11) | (l3.incar==1 & newyear == 11) | (l4.incar==1 & newyear == 11) | (l5.incar==1 & newyear == 11) | (l6.incar==1 & newyear == 11) | (l7.incar==1 & newyear == 11) | (l8.incar==1 & newyear == 11) | (l9.incar==1 & newyear == 11) | (l10.incar==1 & newyear == 11) replace everincar = 1 if (incar==1 & newyear==12) | (l.incar==1 & newyear==12) | (l2.incar==1 & newyear == 12) | (l3.incar==1 & newyear == 12) | (l4.incar==1 & newyear == 12) | (l5.incar==1 & newyear == 12) | (l6.incar==1 & newyear == 12) | (l7.incar==1 & newyear == 12) | (l8.incar==1 & newyear == 12) | (l9.incar==1 & newyear == 12) | (l10.incar==1 & newyear == 12) | (l11.incar==1 & newyear == 12) replace everincar = 1 if (incar==1 & newyear==13) | (l.incar==1 & newyear==13) | (l2.incar==1 & newyear == 13) | (l3.incar==1 & newyear == 13) | (l4.incar==1 & newyear == 13) | (l5.incar==1 & newyear == 13) | (l6.incar==1 & newyear == 13) | (l7.incar==1 & newyear == 13) | (l8.incar==1 & newyear == 13) | (l9.incar==1 & newyear == 13) | (l10.incar==1 & newyear == 13) | (l11.incar==1 & newyear == 13) | (l12.incar==1 & newyear == 13) replace everincar = 1 if (incar==1 & newyear==14) | (l.incar==1 & newyear==14) | (l2.incar==1 & newyear == 14) | (l3.incar==1 & newyear == 14) | (l4.incar==1 & newyear == 14) | (l5.incar==1 & newyear == 14) | (l6.incar==1 & newyear == 14) | (l7.incar==1 & newyear == 14) | (l8.incar==1 & newyear == 14) | (l9.incar==1 & newyear == 14) | (l10.incar==1 & newyear == 14) | (l11.incar==1 & newyear == 14) | (l12.incar==1 & newyear == 14) | (l13.incar==1 & newyear == 14) replace everincar = 1 if (incar==1 & newyear==15) | (l.incar==1 & newyear==15) | (l2.incar==1 & newyear == 15) | (l3.incar==1 & newyear == 15) | (l4.incar==1 & newyear == 15) | (l5.incar==1 & newyear == 15) | (l6.incar==1 & newyear == 15) | (l7.incar==1 & newyear == 15) | (l8.incar==1 & newyear == 15) | (l9.incar==1 & newyear == 15) | (l10.incar==1 & newyear == 15) | (l11.incar==1 & newyear == 15) | (l12.incar==1 & newyear == 15) | (l13.incar==1 & newyear == 15) | (l14.incar==1 & newyear == 15) replace everincar = 1 if (incar==1 & newyear==16) | (l.incar==1 & newyear==16) | (l2.incar==1 & newyear == 16) | (l3.incar==1 & newyear == 16) | (l4.incar==1 & newyear == 16) | (l5.incar==1 & newyear == 16) | (l6.incar==1 & newyear == 16) | (l7.incar==1 & newyear == 16) | (l8.incar==1 & newyear == 16) | (l9.incar==1 & newyear == 16) | (l10.incar==1 & newyear == 16) | (l11.incar==1 & newyear == 16) | (l12.incar==1 & newyear == 16) | (l13.incar==1 & newyear == 16) | (l14.incar==1 & newyear == 16) | (l15.incar==1 & newyear == 16) replace everincar = 1 if (incar==1 & newyear==17) | (l.incar==1 & newyear==17) | (l2.incar==1 & newyear == 17) | (l3.incar==1 & newyear == 17) | (l4.incar==1 & newyear == 17) | (l5.incar==1 & newyear == 17) | (l6.incar==1 & newyear == 17) | (l7.incar==1 & newyear == 17) | (l8.incar==1 & newyear == 17) | (l9.incar==1 & newyear == 17) | (l10.incar==1 & newyear == 17) | (l11.incar==1 & newyear == 17) | (l12.incar==1 & newyear == 17) | (l13.incar==1 & newyear == 17) | (l14.incar==1 & newyear == 17) | (l15.incar==1 & newyear == 17) | (l16.incar==1 & newyear == 17) replace everincar = 1 if (incar==1 & newyear==18) | (l.incar==1 & newyear==18) | (l2.incar==1 & newyear == 18) | (l3.incar==1 & newyear == 18) | (l4.incar==1 & newyear == 18) | (l5.incar==1 & newyear == 18) | (l6.incar==1 & newyear == 18) | (l7.incar==1 & newyear == 18) | (l8.incar==1 & newyear == 18) | (l9.incar==1 & newyear == 18) | (l10.incar==1 & newyear == 18) | (l11.incar==1 & newyear == 18) | (l12.incar==1 & newyear == 18) | (l13.incar==1 & newyear == 18) | (l14.incar==1 & newyear == 18) | (l15.incar==1 & newyear == 18) | (l16.incar==1 & newyear == 18) | (l17.incar==1 & newyear == 18) *generate incarfilter* gen everincar620=0 replace everincar620=1 if everincar==1 & year==98 by CASEID: egen float incarfilter = max(everincar620) *generate non-missing indicator* gen incar3 = 0 replace incar3 = 1 if HH1_1y==-4 | HH1_1y>-1 gen nomiss = 0 replace nomiss = 1 if newyear==1 & incar3==1 replace nomiss = 1 if (incar3==1 & newyear==2) & (l.incar3==1 & newyear==2) replace nomiss = 1 if (incar3==1 & newyear==3) & (l.incar3==1 & newyear==3) & (l2.incar3==1 & newyear == 3) replace nomiss = 1 if (incar3==1 & newyear==4) & (l.incar3==1 & newyear==4) & (l2.incar3==1 & newyear == 4) & (l3.incar3==1 & newyear == 4) replace nomiss = 1 if (incar3==1 & newyear==5) & (l.incar3==1 & newyear==5) & (l2.incar3==1 & newyear == 5) & (l3.incar3==1 & newyear == 5) & (l4.incar3==1 & newyear == 5) replace nomiss = 1 if (incar3==1 & newyear==6) & (l.incar3==1 & newyear==6) & (l2.incar3==1 & newyear == 6) & (l3.incar3==1 & newyear == 6) & (l4.incar3==1 & newyear == 6) & (l5.incar3==1 & newyear == 6) replace nomiss = 1 if (incar3==1 & newyear==7) & (l.incar3==1 & newyear==7) & (l2.incar3==1 & newyear == 7) & (l3.incar3==1 & newyear == 7) & (l4.incar3==1 & newyear == 7) & (l5.incar3==1 & newyear == 7) & (l6.incar3==1 & newyear == 7) replace nomiss = 1 if (incar3==1 & newyear==8) & (l.incar3==1 & newyear==8) & (l2.incar3==1 & newyear == 8) & (l3.incar3==1 & newyear == 8) & (l4.incar3==1 & newyear == 8) & (l5.incar3==1 & newyear == 8) & (l6.incar3==1 & newyear == 8) & (l7.incar3==1 & newyear == 8) replace nomiss = 1 if (incar3==1 & newyear==9) & (l.incar3==1 & newyear==9) & (l2.incar3==1 & newyear == 9) & (l3.incar3==1 & newyear == 9) & (l4.incar3==1 & newyear == 9) & (l5.incar3==1 & newyear == 9) & (l6.incar3==1 & newyear == 9) & (l7.incar3==1 & newyear == 9) & (l8.incar3==1 & newyear == 9) replace nomiss = 1 if (incar3==1 & newyear==10) & (l.incar3==1 & newyear==10) & (l2.incar3==1 & newyear == 10) & (l3.incar3==1 & newyear == 10) & (l4.incar3==1 & newyear == 10) & (l5.incar3==1 & newyear == 10) & (l6.incar3==1 & newyear == 10) & (l7.incar3==1 & newyear == 10) & (l8.incar3==1 & newyear == 10) & (l9.incar3==1 & newyear == 10) replace nomiss = 1 if (incar3==1 & newyear==11) & (l.incar3==1 & newyear==11) & (l2.incar3==1 & newyear == 11) & (l3.incar3==1 & newyear == 11) & (l4.incar3==1 & newyear == 11) & (l5.incar3==1 & newyear == 11) & (l6.incar3==1 & newyear == 11) & (l7.incar3==1 & newyear == 11) & (l8.incar3==1 & newyear == 11) & (l9.incar3==1 & newyear == 11) & (l10.incar3==1 & newyear == 11) replace nomiss = 1 if (incar3==1 & newyear==12) & (l.incar3==1 & newyear==12) & (l2.incar3==1 & newyear == 12) & (l3.incar3==1 & newyear == 12) & (l4.incar3==1 & newyear == 12) & (l5.incar3==1 & newyear == 12) & (l6.incar3==1 & newyear == 12) & (l7.incar3==1 & newyear == 12) & (l8.incar3==1 & newyear == 12) & (l9.incar3==1 & newyear == 12) & (l10.incar3==1 & newyear == 12) & (l11.incar3==1 & newyear == 12) replace nomiss = 1 if (incar3==1 & newyear==13) & (l.incar3==1 & newyear==13) & (l2.incar3==1 & newyear == 13) & (l3.incar3==1 & newyear == 13) & (l4.incar3==1 & newyear == 13) & (l5.incar3==1 & newyear == 13) & (l6.incar3==1 & newyear == 13) & (l7.incar3==1 & newyear == 13) & (l8.incar3==1 & newyear == 13) & (l9.incar3==1 & newyear == 13) & (l10.incar3==1 & newyear == 13) & (l11.incar3==1 & newyear == 13) & (l12.incar3==1 & newyear == 13) replace nomiss = 1 if (incar3==1 & newyear==14) & (l.incar3==1 & newyear==14) & (l2.incar3==1 & newyear == 14) & (l3.incar3==1 & newyear == 14) & (l4.incar3==1 & newyear == 14) & (l5.incar3==1 & newyear == 14) & (l6.incar3==1 & newyear == 14) & (l7.incar3==1 & newyear == 14) & (l8.incar3==1 & newyear == 14) & (l9.incar3==1 & newyear == 14) & (l10.incar3==1 & newyear == 14) & (l11.incar3==1 & newyear == 14) & (l12.incar3==1 & newyear == 14) & (l13.incar3==1 & newyear == 14) replace nomiss = 1 if (incar3==1 & newyear==15) & (l.incar3==1 & newyear==15) & (l2.incar3==1 & newyear == 15) & (l3.incar3==1 & newyear == 15) & (l4.incar3==1 & newyear == 15) & (l5.incar3==1 & newyear == 15) & (l6.incar3==1 & newyear == 15) & (l7.incar3==1 & newyear == 15) & (l8.incar3==1 & newyear == 15) & (l9.incar3==1 & newyear == 15) & (l10.incar3==1 & newyear == 15) & (l11.incar3==1 & newyear == 15) & (l12.incar3==1 & newyear == 15) & (l13.incar3==1 & newyear == 15) & (l14.incar3==1 & newyear == 15) replace nomiss = 1 if (incar3==1 & newyear==16) & (l.incar3==1 & newyear==16) & (l2.incar3==1 & newyear == 16) & (l3.incar3==1 & newyear == 16) & (l4.incar3==1 & newyear == 16) & (l5.incar3==1 & newyear == 16) & (l6.incar3==1 & newyear == 16) & (l7.incar3==1 & newyear == 16) & (l8.incar3==1 & newyear == 16) & (l9.incar3==1 & newyear == 16) & (l10.incar3==1 & newyear == 16) & (l11.incar3==1 & newyear == 16) & (l12.incar3==1 & newyear == 16) & (l13.incar3==1 & newyear == 16) & (l14.incar3==1 & newyear == 16) & (l15.incar3==1 & newyear == 16) replace nomiss = 1 if (incar3==1 & newyear==17) & (l.incar3==1 & newyear==17) & (l2.incar3==1 & newyear == 17) & (l3.incar3==1 & newyear == 17) & (l4.incar3==1 & newyear == 17) & (l5.incar3==1 & newyear == 17) & (l6.incar3==1 & newyear == 17) & (l7.incar3==1 & newyear == 17) & (l8.incar3==1 & newyear == 17) & (l9.incar3==1 & newyear == 17) & (l10.incar3==1 & newyear == 17) & (l11.incar3==1 & newyear == 17) & (l12.incar3==1 & newyear == 17) & (l13.incar3==1 & newyear == 17) & (l14.incar3==1 & newyear == 17) & (l15.incar3==1 & newyear == 17) & (l16.incar3==1 & newyear == 17) replace nomiss = 1 if (incar3==1 & newyear==18) & (l.incar3==1 & newyear==18) & (l2.incar3==1 & newyear == 18) & (l3.incar3==1 & newyear == 18) & (l4.incar3==1 & newyear == 18) & (l5.incar3==1 & newyear == 18) & (l6.incar3==1 & newyear == 18) & (l7.incar3==1 & newyear == 18) & (l8.incar3==1 & newyear == 18) & (l9.incar3==1 & newyear == 18) & (l10.incar3==1 & newyear == 18) & (l11.incar3==1 & newyear == 18) & (l12.incar3==1 & newyear == 18) & (l13.incar3==1 & newyear == 18) & (l14.incar3==1 & newyear == 18) & (l15.incar3==1 & newyear == 18) & (l16.incar3==1 & newyear == 18) & (l17.incar3==1 & newyear == 18) *drop 1987 since race is missing* drop if year==87 *create new continuous year variable for the panel* gen lagyear=newyear replace lagyear =newyear-1 if newyear>8 *declare data to be a panel using lagyear and CASEID* tsset CASEID lagyear, yearly *Table 1* proportion race if race>0 & l.race==1 & incar==0 proportion race if race>0 & l.race==1 & incar==1 proportion race if race>0 & l.race==2 & incar==0 proportion race if race>0 & l.race==2 & incar==1 *Table 2* proportion race if race>0 & incarfilter==1 & everincar==0 proportion race if race>0 & incarfilter==1 & everincar==1 *Table 3* proportion race if incarfilter==1 & everincar==0 & f.incar==1 & incar==0 & race>0 & f.race>0 proportion race if incarfilter==1 & l.everincar==0 & incar==1 & l.incar==0 & race>0 & l.race>0 *Table 4* quietly tabulate lagyear, generate(yr_) xtreg black incar yr_* if race>0, fe cluster(CASEID) xtreg white incar yr_* if race>0, fe cluster(CASEID) xtreg black incar2 yr_* if race>0, fe cluster(CASEID) xtreg white incar2 yr_* if race>0, fe cluster(CASEID) *Table 5 (in Supplementary Materials)* xtreg black everincar yr_* if race>0, fe cluster(CASEID) xtreg black everincar yr_* if race>0 & nomiss==1, fe cluster(CASEID) xtreg white everincar yr_* if race>0, fe cluster(CASEID) xtreg white everincar yr_* if race>0 & nomiss==1, fe cluster(CASEID)