/*ARREST EVENT HISTORY AND CV PROGRAM including ARREST_STATUS ARREST_LASTINTDATE ARREST_FIRST ARREST_TOTNUM ARREST_MISSNUM ARREST_DATED ARREST_MISSINGDT ARREST_MISSINGYR ARREST_MISSINGMON ARREST_UNDATED; */ /* Variable name QNAME r20arr145 ARREST_STATUS_1992.01 r20arr146 ARREST_STATUS_1992.02 r20arr147 ARREST_STATUS_1992.03 r20arr148 ARREST_STATUS_1992.04 r20arr149 ARREST_STATUS_1992.05 r20arr150 ARREST_STATUS_1992.06 r20arr151 ARREST_STATUS_1992.07 r20arr152 ARREST_STATUS_1992.08 r20arr153 ARREST_STATUS_1992.09 r20arr154 ARREST_STATUS_1992.10 r20arr155 ARREST_STATUS_1992.11 r20arr156 ARREST_STATUS_1992.12 r20arr157 ARREST_STATUS_1993.01 r20arr158 ARREST_STATUS_1993.02 r20arr159 ARREST_STATUS_1993.03 r20arr160 ARREST_STATUS_1993.04 r20arr161 ARREST_STATUS_1993.05 r20arr162 ARREST_STATUS_1993.06 r20arr163 ARREST_STATUS_1993.07 r20arr164 ARREST_STATUS_1993.08 r20arr165 ARREST_STATUS_1993.09 r20arr166 ARREST_STATUS_1993.10 r20arr167 ARREST_STATUS_1993.11 r20arr168 ARREST_STATUS_1993.12 r20arr169 ARREST_STATUS_1994.01 r20arr170 ARREST_STATUS_1994.02 r20arr171 ARREST_STATUS_1994.03 r20arr172 ARREST_STATUS_1994.04 r20arr173 ARREST_STATUS_1994.05 r20arr174 ARREST_STATUS_1994.06 r20arr175 ARREST_STATUS_1994.07 r20arr176 ARREST_STATUS_1994.08 r20arr177 ARREST_STATUS_1994.09 r20arr178 ARREST_STATUS_1994.10 r20arr179 ARREST_STATUS_1994.11 r20arr180 ARREST_STATUS_1994.12 r20arr181 ARREST_STATUS_1995.01 r20arr182 ARREST_STATUS_1995.02 r20arr183 ARREST_STATUS_1995.03 r20arr184 ARREST_STATUS_1995.04 r20arr185 ARREST_STATUS_1995.05 r20arr186 ARREST_STATUS_1995.06 r20arr187 ARREST_STATUS_1995.07 r20arr188 ARREST_STATUS_1995.08 r20arr189 ARREST_STATUS_1995.09 r20arr190 ARREST_STATUS_1995.10 r20arr191 ARREST_STATUS_1995.11 r20arr192 ARREST_STATUS_1995.12 r20arr193 ARREST_STATUS_1996.01 r20arr194 ARREST_STATUS_1996.02 r20arr195 ARREST_STATUS_1996.03 r20arr196 ARREST_STATUS_1996.04 r20arr197 ARREST_STATUS_1996.05 r20arr198 ARREST_STATUS_1996.06 r20arr199 ARREST_STATUS_1996.07 r20arr200 ARREST_STATUS_1996.08 r20arr201 ARREST_STATUS_1996.09 r20arr202 ARREST_STATUS_1996.10 r20arr203 ARREST_STATUS_1996.11 r20arr204 ARREST_STATUS_1996.12 r20arr205 ARREST_STATUS_1997.01 r20arr206 ARREST_STATUS_1997.02 r20arr207 ARREST_STATUS_1997.03 r20arr208 ARREST_STATUS_1997.04 r20arr209 ARREST_STATUS_1997.05 r20arr210 ARREST_STATUS_1997.06 r20arr211 ARREST_STATUS_1997.07 r20arr212 ARREST_STATUS_1997.08 r20arr213 ARREST_STATUS_1997.09 r20arr214 ARREST_STATUS_1997.10 r20arr215 ARREST_STATUS_1997.11 r20arr216 ARREST_STATUS_1997.12 r20arr217 ARREST_STATUS_1998.01 r20arr218 ARREST_STATUS_1998.02 r20arr219 ARREST_STATUS_1998.03 r20arr220 ARREST_STATUS_1998.04 r20arr221 ARREST_STATUS_1998.05 r20arr222 ARREST_STATUS_1998.06 r20arr223 ARREST_STATUS_1998.07 r20arr224 ARREST_STATUS_1998.08 r20arr225 ARREST_STATUS_1998.09 r20arr226 ARREST_STATUS_1998.10 r20arr227 ARREST_STATUS_1998.11 r20arr228 ARREST_STATUS_1998.12 r20arr229 ARREST_STATUS_1999.01 r20arr230 ARREST_STATUS_1999.02 r20arr231 ARREST_STATUS_1999.03 r20arr232 ARREST_STATUS_1999.04 r20arr233 ARREST_STATUS_1999.05 r20arr234 ARREST_STATUS_1999.06 r20arr235 ARREST_STATUS_1999.07 r20arr236 ARREST_STATUS_1999.08 r20arr237 ARREST_STATUS_1999.09 r20arr238 ARREST_STATUS_1999.10 r20arr239 ARREST_STATUS_1999.11 r20arr240 ARREST_STATUS_1999.12 r20arr241 ARREST_STATUS_2000.01 r20arr242 ARREST_STATUS_2000.02 r20arr243 ARREST_STATUS_2000.03 r20arr244 ARREST_STATUS_2000.04 r20arr245 ARREST_STATUS_2000.05 r20arr246 ARREST_STATUS_2000.06 r20arr247 ARREST_STATUS_2000.07 r20arr248 ARREST_STATUS_2000.08 r20arr249 ARREST_STATUS_2000.09 r20arr250 ARREST_STATUS_2000.10 r20arr251 ARREST_STATUS_2000.11 r20arr252 ARREST_STATUS_2000.12 r20arr253 ARREST_STATUS_2001.01 r20arr254 ARREST_STATUS_2001.02 r20arr255 ARREST_STATUS_2001.03 r20arr256 ARREST_STATUS_2001.04 r20arr257 ARREST_STATUS_2001.05 r20arr258 ARREST_STATUS_2001.06 r20arr259 ARREST_STATUS_2001.07 r20arr260 ARREST_STATUS_2001.08 r20arr261 ARREST_STATUS_2001.09 r20arr262 ARREST_STATUS_2001.10 r20arr263 ARREST_STATUS_2001.11 r20arr264 ARREST_STATUS_2001.12 r20arr265 ARREST_STATUS_2002.01 r20arr266 ARREST_STATUS_2002.02 r20arr267 ARREST_STATUS_2002.03 r20arr268 ARREST_STATUS_2002.04 r20arr269 ARREST_STATUS_2002.05 r20arr270 ARREST_STATUS_2002.06 r20arr271 ARREST_STATUS_2002.07 r20arr272 ARREST_STATUS_2002.08 r20arr273 ARREST_STATUS_2002.09 r20arr274 ARREST_STATUS_2002.10 r20arr275 ARREST_STATUS_2002.11 r20arr276 ARREST_STATUS_2002.12 r20arr277 ARREST_STATUS_2003.01 r20arr278 ARREST_STATUS_2003.02 r20arr279 ARREST_STATUS_2003.03 r20arr280 ARREST_STATUS_2003.04 r20arr281 ARREST_STATUS_2003.05 r20arr282 ARREST_STATUS_2003.06 r20arr283 ARREST_STATUS_2003.07 r20arr284 ARREST_STATUS_2003.08 r20arr285 ARREST_STATUS_2003.09 r20arr286 ARREST_STATUS_2003.10 r20arr287 ARREST_STATUS_2003.11 r20arr288 ARREST_STATUS_2003.12 r20arr289 ARREST_STATUS_2004.01 r20arr290 ARREST_STATUS_2004.02 r20arr291 ARREST_STATUS_2004.03 r20arr292 ARREST_STATUS_2004.04 r20arr293 ARREST_STATUS_2004.05 r20arr294 ARREST_STATUS_2004.06 r20arr295 ARREST_STATUS_2004.07 r20arr296 ARREST_STATUS_2004.08 r20arr297 ARREST_STATUS_2004.09 r20arr298 ARREST_STATUS_2004.10 r20arr299 ARREST_STATUS_2004.11 r20arr300 ARREST_STATUS_2004.12 r20arr301 ARREST_STATUS_2005.01 r20arr302 ARREST_STATUS_2005.02 r20arr303 ARREST_STATUS_2005.03 r20arr304 ARREST_STATUS_2005.04 r20arr305 ARREST_STATUS_2005.05 r20arr306 ARREST_STATUS_2005.06 r20arr307 ARREST_STATUS_2005.07 r20arr308 ARREST_STATUS_2005.08 r20arr309 ARREST_STATUS_2005.09 r20arr310 ARREST_STATUS_2005.10 r20arr311 ARREST_STATUS_2005.11 r20arr312 ARREST_STATUS_2005.12 r20arr313 ARREST_STATUS_2006.01 r20arr314 ARREST_STATUS_2006.02 r20arr315 ARREST_STATUS_2006.03 r20arr316 ARREST_STATUS_2006.04 r20arr317 ARREST_STATUS_2006.05 r20arr318 ARREST_STATUS_2006.06 r20arr319 ARREST_STATUS_2006.07 r20arr320 ARREST_STATUS_2006.08 r20arr321 ARREST_STATUS_2006.09 r20arr322 ARREST_STATUS_2006.10 r20arr323 ARREST_STATUS_2006.11 r20arr324 ARREST_STATUS_2006.12 r20arr325 ARREST_STATUS_2007.01 r20arr326 ARREST_STATUS_2007.02 r20arr327 ARREST_STATUS_2007.03 r20arr328 ARREST_STATUS_2007.04 r20arr329 ARREST_STATUS_2007.05 r20arr330 ARREST_STATUS_2007.06 r20arr331 ARREST_STATUS_2007.07 r20arr332 ARREST_STATUS_2007.08 r20arr333 ARREST_STATUS_2007.09 r20arr334 ARREST_STATUS_2007.10 r20arr335 ARREST_STATUS_2007.11 r20arr336 ARREST_STATUS_2007.12 r20arr337 ARREST_STATUS_2008.01 r20arr338 ARREST_STATUS_2008.02 r20arr339 ARREST_STATUS_2008.03 r20arr340 ARREST_STATUS_2008.04 r20arr341 ARREST_STATUS_2008.05 r20arr342 ARREST_STATUS_2008.06 r20arr343 ARREST_STATUS_2008.07 r20arr344 ARREST_STATUS_2008.08 r20arr345 ARREST_STATUS_2008.09 r20arr346 ARREST_STATUS_2008.10 r20arr347 ARREST_STATUS_2008.11 r20arr348 ARREST_STATUS_2008.12 r20arr349 ARREST_STATUS_2009.01 r20arr350 ARREST_STATUS_2009.02 r20arr351 ARREST_STATUS_2009.03 r20arr352 ARREST_STATUS_2009.04 r20arr353 ARREST_STATUS_2009.05 r20arr354 ARREST_STATUS_2009.06 r20arr355 ARREST_STATUS_2009.07 r20arr356 ARREST_STATUS_2009.08 r20arr357 ARREST_STATUS_2009.09 r20arr358 ARREST_STATUS_2009.10 r20arr359 ARREST_STATUS_2009.11 r20arr360 ARREST_STATUS_2009.12 r20arr361 ARREST_STATUS_2010.01 r20arr362 ARREST_STATUS_2010.02 r20arr363 ARREST_STATUS_2010.03 r20arr364 ARREST_STATUS_2010.04 r20arr365 ARREST_STATUS_2010.05 r20arr366 ARREST_STATUS_2010.06 r20arr367 ARREST_STATUS_2010.07 r20arr368 ARREST_STATUS_2010.08 r20arr369 ARREST_STATUS_2010.09 r20arr370 ARREST_STATUS_2010.10 r20arr371 ARREST_STATUS_2010.11 r20arr372 ARREST_STATUS_2010.12 r20arr373 ARREST_STATUS_2011.01 r20arr374 ARREST_STATUS_2011.02 r20arr375 ARREST_STATUS_2011.03 r20arr376 ARREST_STATUS_2011.04 r20arr377 ARREST_STATUS_2011.05 r20arr378 ARREST_STATUS_2011.06 r20arr379 ARREST_STATUS_2011.07 r20arr380 ARREST_STATUS_2011.08 r20arr381 ARREST_STATUS_2011.09 r20arr382 ARREST_STATUS_2011.10 r20arr383 ARREST_STATUS_2011.11 r20arr384 ARREST_STATUS_2011.12 r20arr385 ARREST_STATUS_2012.01 r20arr386 ARREST_STATUS_2012.02 r20arr387 ARREST_STATUS_2012.03 r20arr388 ARREST_STATUS_2012.04 r20arr389 ARREST_STATUS_2012.05 r20arr390 ARREST_STATUS_2012.06 r20arr391 ARREST_STATUS_2012.07 r20arr392 ARREST_STATUS_2012.08 r20arr393 ARREST_STATUS_2012.09 r20arr394 ARREST_STATUS_2012.10 r20arr395 ARREST_STATUS_2012.11 r20arr396 ARREST_STATUS_2012.12 r20arr397 ARREST_STATUS_2013.01 r20arr398 ARREST_STATUS_2013.02 r20arr399 ARREST_STATUS_2013.03 r20arr400 ARREST_STATUS_2013.04 r20arr401 ARREST_STATUS_2013.05 r20arr402 ARREST_STATUS_2013.06 r20arr403 ARREST_STATUS_2013.07 r20arr404 ARREST_STATUS_2013.08 r20arr405 ARREST_STATUS_2013.09 r20arr406 ARREST_STATUS_2013.10 r20arr407 ARREST_STATUS_2013.11 r20arr408 ARREST_STATUS_2013.12 r20arr409 ARREST_STATUS_2014.01 r20arr410 ARREST_STATUS_2014.02 r20arr411 ARREST_STATUS_2014.03 r20arr412 ARREST_STATUS_2014.04 r20arr413 ARREST_STATUS_2014.05 r20arr414 ARREST_STATUS_2014.06 r20arr415 ARREST_STATUS_2014.07 r20arr416 ARREST_STATUS_2014.08 r20arr417 ARREST_STATUS_2014.09 r20arr418 ARREST_STATUS_2014.10 r20arr419 ARREST_STATUS_2014.11 r20arr420 ARREST_STATUS_2014.12 r20arr421 ARREST_STATUS_2015.01 r20arr422 ARREST_STATUS_2015.02 r20arr423 ARREST_STATUS_2015.03 r20arr424 ARREST_STATUS_2015.04 r20arr425 ARREST_STATUS_2015.05 r20arr426 ARREST_STATUS_2015.06 r20arr427 ARREST_STATUS_2015.07 r20arr428 ARREST_STATUS_2015.08 r20arr429 ARREST_STATUS_2015.09 r20arr430 ARREST_STATUS_2015.10 r20arr431 ARREST_STATUS_2015.11 r20arr432 ARREST_STATUS_2015.12 r20arr433 ARREST_STATUS_2016.01 r20arr434 ARREST_STATUS_2016.02 r20arr435 ARREST_STATUS_2016.03 r20arr436 ARREST_STATUS_2016.04 r20arr437 ARREST_STATUS_2016.05 r20arr438 ARREST_STATUS_2016.06 r20arr439 ARREST_STATUS_2016.07 r20arr440 ARREST_STATUS_2016.08 r20arr441 ARREST_STATUS_2016.09 r20arr442 ARREST_STATUS_2016.10 r20arr443 ARREST_STATUS_2016.11 r20arr444 ARREST_STATUS_2016.12 r20arr445 ARREST_STATUS_2017.01 r20arr446 ARREST_STATUS_2017.02 r20arr447 ARREST_STATUS_2017.03 r20arr448 ARREST_STATUS_2017.04 r20arr449 ARREST_STATUS_2017.05 r20arr450 ARREST_STATUS_2017.06 r20arr451 ARREST_STATUS_2017.07 r20arr452 ARREST_STATUS_2017.08 r20arr453 ARREST_STATUS_2017.09 r20arr454 ARREST_STATUS_2017.10 r20arr455 ARREST_STATUS_2017.11 r20arr456 ARREST_STATUS_2017.12 r20arr457 ARREST_STATUS_2018.01 r20arr458 ARREST_STATUS_2018.02 r20arr459 ARREST_STATUS_2018.03 r20arr460 ARREST_STATUS_2018.04 r20arr461 ARREST_STATUS_2018.05 r20arr462 ARREST_STATUS_2018.06 r20arr463 ARREST_STATUS_2018.07 r20arr464 ARREST_STATUS_2018.08 r20arr465 ARREST_STATUS_2018.09 r20arr466 ARREST_STATUS_2018.10 r20arr467 ARREST_STATUS_2018.11 r20arr468 ARREST_STATUS_2018.12 r20arr469 ARREST_STATUS_2019.01 r20arr470 ARREST_STATUS_2019.02 r20arr471 ARREST_STATUS_2019.03 r20arr472 ARREST_STATUS_2019.04 r20arr473 ARREST_STATUS_2019.05 r20arr474 ARREST_STATUS_2019.06 r20arr475 ARREST_STATUS_2019.07 r20arr476 ARREST_STATUS_2019.08 r20arr477 ARREST_STATUS_2019.09 r20arr478 ARREST_STATUS_2019.10 r20arr479 ARREST_STATUS_2019.11 r20arr480 ARREST_STATUS_2019.12 r20arr481 ARREST_STATUS_2020.01 r20arr482 ARREST_STATUS_2020.02 r20arr483 ARREST_STATUS_2020.03 r20arr484 ARREST_STATUS_2020.04 r20arr485 ARREST_STATUS_2020.05 r20arr486 ARREST_STATUS_2020.06 r20arr487 ARREST_STATUS_2020.07 r20arr488 ARREST_STATUS_2020.08 r20arr489 ARREST_STATUS_2020.09 r20arr490 ARREST_STATUS_2020.10 r20arr491 ARREST_STATUS_2020.11 r20arr492 ARREST_STATUS_2020.12 r20arr493 ARREST_STATUS_2020.01 r20arr494 ARREST_STATUS_2020.02 r20arr495 ARREST_STATUS_2020.03 r20arr496 ARREST_STATUS_2020.04 r20arr497 ARREST_STATUS_2020.05 r20arr498 ARREST_STATUS_2020.06 r20arr499 ARREST_STATUS_2020.07 r20arr500 ARREST_STATUS_2020.08 r20arr501 ARREST_STATUS_2020.09 r20arr502 ARREST_STATUS_2020.10 r20arr503 ARREST_STATUS_2020.11 r20arr504 ARREST_STATUS_2020.12 r20arr505 ARREST_STATUS_2020.01 r20arr506 ARREST_STATUS_2020.02 r20arr507 ARREST_STATUS_2020.03 r20arr508 ARREST_STATUS_2020.04 r20arr509 ARREST_STATUS_2020.05 r20arr510 ARREST_STATUS_2020.06 r20arr511 ARREST_STATUS_2020.07 r20arr512 ARREST_STATUS_2020.08 r20arr513 ARREST_STATUS_2020.09 r20arr514 ARREST_STATUS_2020.10 r20ARREST_FIRST ARREST_FIRST r20ARREST_TOTNUM ARREST_TOTNUM r20ARREST_MISSNUM ARREST_MISSNUM r20ARREST_DATED ARREST_DATED r20ARREST_UNDATED ARREST_UNDATED r20ARREST_MISSINGDT ARREST_MISSINGDT r20ARREST_MISSINGYR ARREST_MISSINGYR r20ARREST_MISSINGMON ARREST_MISSINGMON r20ARREST_UNASKED ARREST_UNASKED r20ARREST_LASTINTDATE ARREST_LASTINTDATE int_cmr1 CV_INTERVIEW_CMONTH_1997 int_Dr1 CV_INTERVIEW_DATE_D_1997 int_Mr1 CV_INTERVIEW_DATE_M_1997 int_Yr1 CV_INTERVIEW_DATE_Y_1997 int_cmr2 CV_INTERVIEW_CMONTH_1998 int_Dr2 CV_INTERVIEW_DATE~D_1998 int_Mr2 CV_INTERVIEW_DATE~M_1998 int_Yr2 CV_INTERVIEW_DATE~Y_1998 int_cmr3 CV_INTERVIEW_CMONTH_1999 int_Dr3 CV_INTERVIEW_DATE~D_1999 int_Mr3 CV_INTERVIEW_DATE~M_1999 int_Yr3 CV_INTERVIEW_DATE~Y_1999 int_cmr4 CV_INTERVIEW_CMONTH_2000 int_Dr4 CV_INTERVIEW_DATE~D_2000 int_Mr4 CV_INTERVIEW_DATE~M_2000 int_Yr4 CV_INTERVIEW_DATE~Y_2000 int_cmr5 CV_INTERVIEW_CMONTH_2001 int_Dr5 CV_INTERVIEW_DATE~D_2001 int_Mr5 CV_INTERVIEW_DATE~M_2001 int_Yr5 CV_INTERVIEW_DATE~Y_2001 int_cmr6 CV_INTERVIEW_CMONTH_2002 int_Dr6 CV_INTERVIEW_DATE~D_2002 int_Mr6 CV_INTERVIEW_DATE~M_2002 int_Yr6 CV_INTERVIEW_DATE~Y_2002 int_cmr7 CV_INTERVIEW_CMONTH_2003 int_Dr7 CV_INTERVIEW_DATE~D_2003 int_Mr7 CV_INTERVIEW_DATE~M_2003 int_Yr7 CV_INTERVIEW_DATE~Y_2003 int_cmr8 CV_INTERVIEW_CMONTH_2004 int_Dr8 CV_INTERVIEW_DATE~D_2004 int_Mr8 CV_INTERVIEW_DATE~M_2004 int_Yr8 CV_INTERVIEW_DATE~Y_2004 int_cmr9 CV_INTERVIEW_CMONTH_2005 int_Dr9 CV_INTERVIEW_DATE~D_2005 int_Mr9 CV_INTERVIEW_DATE~M_2005 int_Yr9 CV_INTERVIEW_DATE~Y_2005 int_cmr10 CV_INTERVIEW_CMONTH_2006 int_Dr10 CV_INTERVIEW_DATE~D_2006 int_Mr10 CV_INTERVIEW_DATE~M_2006 int_Yr10 CV_INTERVIEW_DATE~Y_2006 int_cmr11 CV_INTERVIEW_CMONTH_2007 int_Dr11 CV_INTERVIEW_DATE~D_2007 int_Mr11 CV_INTERVIEW_DATE~M_2007 int_Yr11 CV_INTERVIEW_DATE~Y_2007 int_cmr12 CV_INTERVIEW_CMONTH_2008 int_Dr12 CV_INTERVIEW_DATE~D_2008 int_Mr12 CV_INTERVIEW_DATE~M_2008 int_Yr12 CV_INTERVIEW_DATE~Y_2008 int_cmr13 CV_INTERVIEW_CMONTH_2009 int_Dr13 CV_INTERVIEW_DATE~D_2009 int_Mr13 CV_INTERVIEW_DATE~M_2009 int_Yr13 CV_INTERVIEW_DATE~Y_2009 int_cmr14 CV_INTERVIEW_CMONTH_2010 int_Dr14 CV_INTERVIEW_DATE~D_2010 int_Mr14 CV_INTERVIEW_DATE~M_2010 int_Yr14 CV_INTERVIEW_DATE~Y_2010 int_cmr15 CV_INTERVIEW_CMONTH_2011 int_Dr15 CV_INTERVIEW_DATE~D_2011 int_Mr15 CV_INTERVIEW_DATE~M_2011 int_Yr15 CV_INTERVIEW_DATE~Y_2011 int_cmr16 CV_INTERVIEW_CMONTH_2013 int_Dr16 CV_INTERVIEW_DATE~D_2013 int_Mr16 CV_INTERVIEW_DATE~M_2013 int_Yr16 CV_INTERVIEW_DATE~Y_2013 int_cmr17 CV_INTERVIEW_CMONTH_2015 int_dr17 CV_INTERVIEW_DATE~D_2015 int_mr17 CV_INTERVIEW_DATE~M_2015 int_Yr17 CV_INTERVIEW_DATE~Y_2015 int_cmr18 CV_INTERVIEW_CMONTH_2017 int_dr18 CV_INTERVIEW_DATE~D_2017 int_mr18 CV_INTERVIEW_DATE~M_2017 int_Yr18 CV_INTERVIEW_DATE~Y_2017 int_cmr19 CV_INTERVIEW_CMONTH_2019 int_mr19 CV_INTERVIEW_DATE~M_2019 int_Yr19 CV_INTERVIEW_DATE~Y_2019 int_cmr20 CV_INTERVIEW_CMONTH_2021 int_mr20 CV_INTERVIEW_DATE~M_2021 int_Yr20 CV_INTERVIEW_DATE~Y_2021 int_cm CV_INTERVIEW_CMONTH_2023 int_D CV_INTERVIEW_DATE~D_2023 int_M CV_INTERVIEW_DATE~M_2023 int_y CV_INTERVIEW_DATE~Y_2023 A441 YSAQF-441_2021 A443 YSAQF-443_2021 A443AM1 YSAQF-443A1_2021 A443AY1 YSAQF-443A2~Y_2021 A443A2A YSAQF-443A2A_2021 A443AM2 YSAQF-443A3_2021 A443AY2 YSAQF-443A4~Y_2021 A453M1 YSAQF-453.01_2021 A453M2 YSAQF-453.02_2021 A453M3 YSAQF-453.03_2021 A453M4 YSAQF-453.04_2021 A454Y1 YSAQF-454.01~Y_2021 A454Y2 YSAQF-454.02~Y_2021 A454Y3 YSAQF-454.03~Y_2021 A454Y4 YSAQF-454.04~Y_2021 */ options pagesize=54 linesize=93 nocenter nodate; libname r21arr 'J:\R21 Arrest'; options symbolgen; %macro c_month ( mo , ye, cm); if &mo.>0 & &ye.>0 then &cm=(&ye.-1980)*12+&mo.; if &Ye =-5 then &cm=-5; %mend c_month ; %macro c_iym(mo, ye, iym, dlidate); &iym.=-4; if &mo.>0 & &ye.>0 then &iym=&ye.*100+&mo.; if &ye.=-5 then &iym.=&dlidate.; %mend c_iym ; /* Read in R21 and arrest variables as of R20 */ data oneA; set r21arr.r21arrest_vars; run; proc freq data=oneA; title 'Number of arrests R21'; tables a441 a443; run; proc freq data=onea; where int_y gt 0; tables r20arrest_lastintdate; run; proc print data=oneA noobs; title 'one two or three arrests since DLI'; where a443 in (1,2,3) ; var pubid a443 A453m1 a454y1 a453m2 a454y2 a453m3 a454y3 r20arrest_lastintdate; run; proc print data=oneA noobs; title 'one two or three arrests since DLI missing some date info'; where a443 in (1,2,3) and (a453m1 in (-3,-2,-1) or a454y1 in (-3,-2,-1) or a453m2 in (-3,-2,-1) or a454y2 in (-3,-2,-1) or a453m3 in (-3,-2,-1) or a454y3 in (-3,-2,-1)) ; var pubid a443 A453m1 a454y1 a453m2 a454y2 a453m3 a454y3 r20arrest_lastintdate; run; proc print data=oneA noobs; title 'More than 3 arrests since DLI'; where a443 gt 3; var pubid A443 A443a:; run; proc print data=oneA; where a443 gt 3; var pubid r20arrest: arrest:; run; proc freq data=oneA; title "# of arrests is DK or REF"; where a443 in (-2,-1); tables A443 A443a: a453: a454:; run; proc print data=oneA noobs; title "# of arrests is DK or REF"; where a443 in (-2,-1); var pubid a453: a454:; run; proc freq data=oneA; title 'number of arrests for those who say DK/REF to whether been arrested since DLI'; where a441 in (-2,-1); tables a441 a443; run; /* More than 3 arrests since DLI, DK month or year Where first or last arrest year or month was missing it was imputed on a case by case basis based on last interview date and known arrest date information. If respondents cannot provide only the arrest month, then it is imputed using the month of the middle of the period since the last interview date. For example, if a respondent was interviewed in Round 6 and in Round 8, but not in Round 7, the program will take the month from the mid-date between Round 6's interview date and Round 8's interview date. */ proc print data=oneA noobs; where a443 gt 3 and (a443am1 in (-3,-2,-1) or a443ay1 in (-3,-2,-1) or a443am2 in (-3,-2,-1) or a443ay2 in (-3,-2,-1)); var pubid A443 a443am1 a443ay1 a443am2 a443ay2 r20arrest_lastintdate int_m int_Y; run; proc freq data=onea; where int_y ne -5; tables r20arrest_lastintdate; run; proc print data=onea; where int_y ne -5 and r20arrest_lastintdate=199702; var pubid; run; data one; set oneA; %let n=20; /* # of last round = R20 */ /* was 19 in R20 program */ %let L=537; /*Last continuous month of current round (doicm)*/ /* was 514 in R20 program */ %let E=514; /* the latest month of dli event history */ /* was 487 in R20 program */ %let S=208; /* the earliest start month of current round */ /* I think this is earliest START (DLIcm+1): was 207 in R19; was 210 in R18; was 207 for R17 R16 R15; 283 in R14 */ %let I=20; /* A443: Maximum total number of times arrested plus one (plus one added R19) (plus two added R21 to account for 5 or more arrests within 2 months)*/ /* was 51 in R19 program */ %let A=5; /* Due to current looping structure in survey, 3 is the maximum number of arrest dates that can be reported A=5 so comparisons can be made later in the program*/ array int_mr(&n); array int_yr(&n); array int_Dr(&n); array int_cmr(&n); array R20arr(&E); array arr(&L); array A443AM(&A); array A443AY(&A); array A453M(&A); array A454Y(&A); array Sarr(&A); /* start month of arrest (in continuous months) */ do i=1 to (&n); if int_cmr(i)>0 then do; dlicm=int_cmr(i); * interview date in continuous months; dliy =int_Yr(i); dliM =int_Mr(i); dliD =int_Dr(i); end; end; /* start is the first continuous month after DLI */ start=dlicm+1; /* In prior round, interview date was system missing for those not interviewed. */ /* In R20, interview date for non-interviews is set to -5s. */ /* Needed to recode -5s to ., otherwise sets dates to -505. */ if int_y=-5 then do; int_y=.; int_m=.; int_d=.; int_cm=.; end; /* mid_month was created when interviews were done yearly and is outdated as it rarely actually captures the correct midpoint between interviews which is intended to be used to impute arrest events for Rs who don't know their arrest months. The created midpoint variable (below) should be used instead. */ /* Using Mipoint is also likely to be imprecise in those cases where R reports year of arrest and it is different than the year provided using midpoint...but midpoint may still provide the best atarting point for checking/cleaning. */ if int_Y >0 then mid_month = MONTH(( MDY(int_M, int_D, int_Y) + MDY(dliM, dliD,dliY))*0.5); %c_month(Mo=int_m, ye=int_y, cm=doicm); %c_iym(Mo=int_m, ye=int_y,iym=ARREST_LASTINTDATE, dlidate=R20ARREST_LASTINTDATE); if int_Y >0 then mid_point_raw = (( doicm + dlicm)*0.5); Midpoint= Round (mid_point_raw, 1); if int_y>0 then do ; /* loop one */ do L=1 to dlicm; if 0-4 & A443AY(A)>-4 then Sarr(A) = (A443AY(A)-1980)*12+ A443AM(A); if sarr(A) >0 & start>0 & sarr(A) < start then back=1; * BACK=1 flag: valid arrest month and start date (in cm) is before DLI ; if (back=1 and A443AY1 = DLIY and A443AM1 in (-1,-2)) then do; mid_month = DLIM+1; /*Adjusts mid_month in cases where it would otherwise be set before DLIM */ back=0; end; if A443AM(A) in (-1 -2) & A443AY(A)>0 then Sarr(A)= (A443AY(A)-1980)*12+ mid_month; if A443AM(A) >0 & A443AY(A) in(-1 -2) | A443AM(A) in(-1 -2) & A443AY(A) in(-1 -2) then Sarr(A)= -4; if A453M(A)>-4 & A454Y(A)>-4 then Sarr(A) = (A454Y(A)-1980)*12+ A453M(A); if sarr(A) >0 & start>0 & sarr(A) < start then back=1; * BACK=1 flag: valid arrest month and start date (in cm) is before DLI ; if (back=1 and A454Y1 = DLIY and A453M1 in (-1,-2)) then do; mid_month = DLIM+1; /*Adjusts mid_month in cases where it would otherwise be set before DLIM */ back=0; end; if A453M(A) in (-1 -2) & A454Y(A)>0 then Sarr(A)=(A454Y(A)-1980)*12+ mid_month; if A453M(A) >0 & A454Y(A) in(-1 -2) | A453M(A) in (-1 -2) & A454Y(A) in (-1 -2) then Sarr(A)=-4; back=0; end; /* calculate the total number of arrests in one month Ysaq-A454*/ /* for those with 3 or fewer arrests */ count_arr=0; do A=1 to (&A); /* loop one */ if A454Y(A)>-4 & (sarr(A)= sarr(A+1) | sarr(A)= sarr(A+2) )& sarr(A)>0 then do; count_arr=count_arr+1; c=sarr(A); end; do l=(&S) to doicm; if sarr(A)>0 & L=sarr(A) then arr(L)=1; else if arr(L)=1 & count_arr>=1 & L=C then arr(L)=arr(L)+ count_arr; if A443>=4 & sarr2=L then arr(L)=99; /***************/ end; end; /* loop one */ /* calculate the total number of arrests in one month Ysaq-A443*/ /* for those with 4 or more arrests */ array sarr_Q(&I); if sarr1>0 & sarr2>0 & A443 >3 then do; /*loop 1*/ * More than 3 arrests since DLI; *distance=abs((Sarr2-Sarr1)/A443); * months between first and last arrest since DLI; distance=abs((Sarr2-Sarr1)/(A443-1)); * R17: changed to A443-1 so last arrest is endpoint of dates; do i=1 to A443; sarr_Q(i)=sarr1+round((i-1)*distance); end; do I=1 to (&I)-1; /* 12-10 */ do l=1 to doicm; if sarr_Q(I)>0 & L=sarr_Q(I) then arr(L)=1; if sarr1=sarr2 & L=sarr1 then Arr(L)=A443; if sarr_Q(I)>0 & sarr_Q(I)=sarr_Q(I+1) & distance ~= 0 then do; c=sarr_Q(I); end; if L=c then arr(L)= 2; if sarr_Q(I)>0 & sarr_Q(I)=sarr_Q(I+2) & distance ~= 0 then do; c1=sarr_Q(I); end; if L=c1 then arr(L)=3; end; end; end; do A=1 to (&A); if Sarr(A)>0 & sarr(A)>=dlicm then do; do l=Sarr(A)+1 to doicm; if arr(L) in (.,-4, 0) then arr(L)=99; end; end; if Sarr(A)<0 then sarr(A)=.; if sarr(A) >0 & start>0 & sarr(A) < start then back=1; * BACK=1 flag: valid arrest month and start date (in cm) is before DLI ; end; /* for cases with 4 or more arrests where both first arrest month and year are -1, -2, AND most recent arrest month and year are -1, -2 adds the number of arrests reported at A443 to R20ARREST_MISSINGDT */ /* ARREST_FIRST Earliest arrest date as reported by R. */ /* Sarr array is the Month of arrest since last DLI in continuous months */ do A=1 to (&A); if Sarr(A)>0 then ARREST_FIRST=min (of sarr1-sarr3); * assign ARREST_FIRST to earliest reported arrest this round; end; if ARREST_FIRST>0 then do; * if there is an arrest this round then do; do l=ARREST_FIRST to dlicm; if back=1 & 0 0 then do; do l=ARREST_FIRST to dlicm; if arr(L) in (-4 . 0) then arr(L)=99; end; end; do A=1 to (&A); if back=1 & chk_99=. & sarr(A)>0 then do; do l=sarr(A) to doicm; if arr(L) in ( 0, ., -4) then arr(L)=99; end; end; end; do A=1 to 3; if sarr(A)>0 & sarr(A+1)>0 & Sarr(A)>sarr(A+1) then chk_sarr=1; if sarr(A)>doicm then chk_sarr=2; end; /* ARREST_FIRST Earliest arrest date as reported by R. */ array sarr_p sarr1 - sarr5; array cvm cvm1-cvm5; array cvy cvy1-cvy5; array cvmy cvmy1-cvmy5; array fir firstc540-firstc157; *check array numbers...set array to Dec of last int year do over sarr_p; do i=540 to 157 by -12; fir=i; if fir-11<=sarr_p<=fir then do; * converts continuous month back to month and year; cvm=sarr_p-(fir-12); * 10/05= 310 10=310-(312-12); cvy=(sarr_p-cvm)/12+1980; cvmy=cvy*100+cvm; end; end; end; end;/* end loop 1*/ R21ARREST_FIRST=min(of cvmy:); * CHECK how this handles missing values; if R20ARREST_FIRST=-4 then R20ARREST_FIRST=.; * cases with no first arrest are set to system missing; ARREST_FIRST = min(R21ARREST_FIRST, R20ARREST_FIRST); * CHECK how this handles missing values; if ARREST_FIRST=. then ARREST_FIRST=-4; * if no first arrest, then set back to -4; if R21ARREST_FIRST=. then R21ARREST_FIRST=-4; /*ARREST_TOTNUM Total number of arrests as reported by R that R refused to answer the question on number of arrests since the date of last interview*/ R21ARREST_TOTNUM =0 ; ARREST_TOTNUM=0; if A443>0 then R21ARREST_TOTNUM=A443; if R21ARREST_TOTNUM >0 then ARREST_TOTNUM=R21ARREST_TOTNUM+ R20ARREST_TOTNUM; * already arrested previously; else ARREST_TOTNUM=R20ARREST_TOTNUM; * not arrested this round; /* ARREST_MISSNUM Total number of rounds (question years) that R refused to answer the question on number of arrests since the date of last interview */ R21ARREST_MISSNUM=0; ARREST_MISSNUM=0; if A443 in (-3, -2, -1) then R21ARREST_MISSNUM=1; ARREST_MISSNUM=R20ARREST_MISSNUM+R21ARREST_MISSNUM; /* ARREST_DATED */ /* need to check what happens if more than 3 arrests */ R21ARREST_DATED=0; ARREST_DATED=0; array countA(&L); if doicm>0 then do; do l=(&S) to doicm; if 00 & R20ARREST_MISSINGDT=0 then do; R21ARREST_FIRST=-3; if R20ARREST_FIRST=0 then ARREST_FIRST=-3; end; end; /* for cases with 4 or more arrests where both first arrest month and year are -1, -2, AND most recent arrest month and year are -1, -2 adds the number of arrests reported at A443 to R20ARREST_MISSINGDT */ if (-40 then Miss_454_Y(i)=1; R21ARREST_MISSINGYR= sum(of Miss_454_Y:); if Miss_454_Y(i)=1 & R20ARREST_FIRST=-4 then do; R21ARREST_FIRST=-3; if R20ARREST_FIRST=0; ARREST_FIRST=-3; /*************/ end; end; ARREST_MISSINGYR = R21ARREST_MISSINGYR +R20ARREST_MISSINGYR; /* ARREST_MISSINGMON Number of arrest dates with missing month.*/ array Miss_454_M(&i); R21ARREST_MISSINGMON=0; ARREST_MISSINGMON=0; do i=1 to 5; Miss_454_M(i)=0; if A454Y(i)>0 & -4