*** 1983 Jail Census *** For this project, I very often use the count, the ADP, the state, *** and a summary of court orders *** So leave the data in order, but create new variables for just those *** characteristics *** I also need a unique id for each facility *** Finally, I put these new variables first in the variable list, *** so that they can be found easily. *** Make sure there's been a path defined for where the data is all kept and saved: *** This ought to be done from a production file, but if not, it's here, commented out. *DEFINE !Path1 ()'C:\\Margo\DATA\BJS\AllCensuses\'!enddefine. *** Open up the data [This is just from the ICPSR data definition statement] *-------------------------------------------------------------------------* | | | SPSS DATA DEFINITION STATEMENTS FOR ICPSR 8203 | | NATIONAL JAIL CENSUS, 1983 | | 1ST ICPSR EDITION | | FEBRUARY 1997 | | | | DATA LIST: assigns the name, type, decimal specification (if any), | | and specifies the beginning and ending column locations for each | | variable in the data file. Users must replace the "physical-filename" | | with host computer specific input file specifications. | | | | VARIABLE LABELS: assigns descriptive labels to all variables. | | variables.abels and variable names may be identical for some | | | | MISSING VALUES: declares user-defined missing values. Not all | | variables in this data file necessarily have user-defined missing | | transformations, statistical calculations, and case selection. | | | | MISSING VALUE RECODE: sets user-defined numeric missing values to | | missing as interpreted by the SPSS system. Only variables with | | user-defined missing values are included in the statements. | | | | VALUE LABELS: assigns descriptive labels to codes in the data file. | | Not all variables necessarily have assigned value labels. | | | | NOTE: Users should modify these data definition statements to suit | | their specific needs. MISSING VALUES and MISSING VALUE RECODE | | sections have been marked by SPSS comment statements. To include these | | sections in a final SPSS setup, users should remove the SPSS comment | | statements from the desired section(s). | | | | These data definition statements have been tested for compatibility | | with SPSS Release 5.0 for UNIX and/or SPSS Release 6.1 for Windows. | *-------------------------------------------------------------------------. * SPSS FILE HANDLE, DATA LIST COMMANDS. FILE HANDLE DATA / NAME=!Path1+"merging\odata[1].s8203" LRECL=1127. DATA LIST FILE=DATA / V1 1-4 V2 5 V3 6 V4 7-10 V5 11-12 V6 13 V7 14-16 V8 17-19 V9 20 V10 21-22 V11 23-24 V12 25 V13 26 V14 27 V15 28-29 V16 30-31 V17 32 V18 33 V19 34 V20 35 V21 36 V22 37 V23 38 V24 39 V25 40 V26 41 V27 42 V28 43 V29 44 V30 45 V31 46 V32 47 V33 48 V34 49 V35 50 V36 51 V37 52 V38 53 V39 54 V40 55-58 V41 59 V42 60-63 V43 64 V44 65-67 V45 68 V46 69-71 V47 72 V48 73-76 V49 77 V50 78-79 V51 80-83 V52 84-89 V53 90-91 V54 92-95 V55 96-101 V56 102-103 V57 104-107 V58 108-109 V59 110-113 V60 114-115 V61 116-117 V62 118-122 V63 123-126 V64 127-130 V65 131-134 V66 135-138 V67 139-142 V68 143-146 V69 147-150 V70 151-154 V71 155-158 V72 159-162 V73 163-166 V74 167-170 V75 171-174 V76 175-178 V77 179-182 V78 183-186 V79 187-190 V80 191-194 V81 195-198 V82 199-202 V83 203-206 V84 207-210 V85 211-214 V86 215-218 V87 219-222 V88 223-225 V89 226-228 V90 229-230 V91 231-233 V92 234-236 V93 237-238 V94 239-240 V95 241-242 V96 243-245 V97 246-248 V98 249-251 V99 252-254 V100 255-257 V101 258-260 V102 261-263 V103 264-266 V104 267-269 V105 270-272 V106 273-275 V107 276-278 V108 279-281 V109 282-284 V110 285-287 V111 288-290 V112 291-294 V113 295-298 V114 299-302 V115 303-306 V116 307-309 V117 310 V118 311-314 V119 315-320 V120 321-326 V121 327-332 V122 333-336 V123 337-340 V124 341-346 V125 347-352 V126 353-358 V127 359-362 V128 363-366 V129 367-368 V130 369-370 V131 371-372 V132 373-374 V133 375-376 V134 377-378 V135 379-380 V136 381-382 V137 383-384 V138 385-386 V139 387-388 V140 389-390 V141 391-392 V142 393-394 V143 395-396 V144 397-398 V145 399-400 V146 401-402 V147 403-404 V148 405-406 V149 407-408 V150 409-410 V151 411-412 V152 413-414 V153 415-416 V154 417 V155 418-420 V156 421-423 V157 424 V158 425 V159 426-428 V160 429-431 V161 432-435 V162 436 V163 437-440 V164 441-445 V165 446-447 V166 448 V167 449 V168 450 V169 451 V170 452-455 V171 456-459 V172 460 V173 461-464 V174 465-469 V175 470-471 V176 472 V177 473 V178 474 V179 475 V180 476-479 V181 480-483 V182 484 V183 485-488 V184 489-493 V185 494-495 V186 496 V187 497 V188 498 V189 499 V190 500-503 V191 504-507 V192 508 V193 509-512 V194 513-517 V195 518-519 V196 520 V197 521 V198 522 V199 523 V200 524-527 V201 528-531 V202 532 V203 533-536 V204 537-541 V205 542-543 V206 544 V207 545 V208 546 V209 547 V210 548-551 V211 552-555 V212 556 V213 557-560 V214 561-565 V215 566-567 V216 568 V217 569 V218 570 V219 571 V220 572-575 V221 576-579 V222 580 V223 581-584 V224 585-589 V225 590-591 V226 592 V227 593 V228 594 V229 595 V230 596-599 V231 600-603 V232 604 V233 605-608 V234 609-613 V235 614-615 V236 616 V237 617 V238 618 V239 619 V240 620-623 V241 624-627 V242 628 V243 629-632 V244 633-637 V245 638-639 V246 640 V247 641 V248 642 V249 643 V250 644-647 V251 648-651 V252 652 V253 653-656 V254 657-661 V255 662-663 V256 664 V257 665 V258 666 V259 667 V260 668-671 V261 672-675 V262 676 V263 677-680 V264 681-685 V265 686-687 V266 688 V267 689 V268 690 V269 691 V270 692-695 V271 696-699 V272 700 V273 701-704 V274 705-709 V275 710-711 V276 712 V277 713 V278 714 V279 715 V280 716-719 V281 720-723 V282 724 V283 725-728 V284 729-733 V285 734-735 V286 736 V287 737 V288 738 V289 739 V290 740-743 V291 744-747 V292 748 V293 749-752 V294 753-757 V295 758-759 V296 760 V297 761 V298 762 V299 763 V300 764-767 V301 768-771 V302 772 V303 773-776 V304 777-781 V305 782-783 V306 784 V307 785 V308 786 V309 787 V310 788-791 V311 792-795 V312 796 V313 797-800 V314 801-805 V315 806-807 V316 808 V317 809 V318 810 V319 811 V320 812-815 V321 816-819 V322 820 V323 821-824 V324 825-829 V325 830-831 V326 832 V327 833 V328 834 V329 835 V330 836-839 V331 840-843 V332 844 V333 845-848 V334 849-853 V335 854-855 V336 856 V337 857 V338 858 V339 859 V340 860-863 V341 864-867 V342 868 V343 869-872 V344 873-877 V345 878-879 V346 880 V347 881 V348 882 V349 883 V350 884-887 V351 888-891 V352 892 V353 893-896 V354 897-901 V355 902-903 V356 904 V357 905 V358 906 V359 907 V360 908-911 V361 912-917 V362 918-921 V363 922-924 V364 925-927 V365 928-930 V366 931-933 V367 934-936 V368 937-939 V369 940-942 V370 943-945 V371 946-948 V372 949-950 V373 951-952 V374 953-956 V375 957-960 V376 961-963 V377 964-966 V378 967-968 V379 969-970 V380 971-973 V381 974-976 V382 977-979 V383 980-982 V384 983-984 V385 985-986 V386 987-989 V387 990-992 V388 993-995 V389 996-998 V390 999-1000 V391 1001-1002 V392 1003-1005 V393 1006-1008 V394 1009-1011 V395 1012-1014 V396 1015-1016 V397 1017-1018 V398 1019-1020 V399 1021-1022 V400 1023-1024 V401 1025-1026 V402 1027-1028 V403 1029-1030 V404 1031-1032 V405 1033-1034 V406 1035-1036 V407 1037-1038 V408 1039-1040 V409 1041-1042 V410 1043-1050 V411 1051-1058 V412 1059-1067 V413 1068-1075 V414 1076-1083 V415 1084 V416 1085 V417 1086 V418 1087 V419 1088 V420 1089 V421 1090 V422 1091 V423 1092 V424 1093 V425 1094 V426 1095 V427 1096 V428 1097 V429 1098 V430 1099 V431 1100 V432 1101 V433 1102 V434 1103 V435 1104 V436 1105 V437 1106 V438 1107 V439 1108 V440 1109 V441 1110 V442 1111 V443 1112 V444 1113 V445 1114 V446 1115 V447 1116 V448 1117 V449 1118-1119 V450 1120 V451 1121 V452 1122-1127. * SPSS VARIABLE LABELS COMMAND. VARIABLE LABELS V1 "ICPSR STUDY NUMBER-8203" V2 "ICPSR VERSION NUMBER-1" V3 "ICPSR PART NUMBER-1" V4 "ICPSR SEQ ID NUMBER" V5 "GOVT ID: STATE" V6 "GOVT ID: LEVEL OF GOVT" V7 "GOVT ID: COUNTY" V8 "GOVT ID: CITY" V9 "CHECK DIGIT" V10 "OLD AGENCY ID: FACILITY" V11 "OLD AGENCY ID:UNIQUE #" V12 "OLD AGENCY ID:SEX" V13 "OLD AGENCY ID:AV POP FEM" V14 "OLD AGENCY ID:AV POP TOT" V15 "NEW AGENCY ID: FACILITY" V16 "NEW AGENCY ID:UNIQUE #" V17 "NEW AGENCY ID:SEX" V18 "NEW AGENCY ID:AV POP FEM" V19 "NEW AGENCY ID:AV POP TOT" V20 "Q.2A1 LOCKUP:ADULT MALE" V21 "Q.2A2 LOCKUP:ADULT FEMAL" V22 "Q.2A3 LOCKUP:JUV MALE" V23 "Q.2A4 LOCKUP:JUV FEMALE" V24 "Q.2B1 LOCAL/ST:ADULT MAL" V25 "Q.2B2 LOCAL/ST:ADULT FEM" V26 "Q.2B3 LOCAL/ST:JUV MALE" V27 "Q.2B4 LOCAL/ST:JUV FEMAL" V28 "Q.2C1 FED:ADULT MALE" V29 "Q.2C2 FED:ADULT FEMALE" V30 "Q.2C3 FED:JUV MALE" V31 "Q.2C4 FED:JUV FEMALE" V32 "Q.2D1 MISDEM:ADULT MALE" V33 "Q.2D2 MISDEM:ADULT FEMAL" V34 "Q.2D3 MISDEM:JUV MALE" V35 "Q.2D4 MISDEM:JUV FEMALE" V36 "Q.2E1 FELONY:ADULT MALE" V37 "Q.2E2 FELONY:ADULT FEMAL" V38 "Q.2E3 FELONY:JUV MALE" V39 "Q.2E4 FELONY:JUV FEMALE" V40 "Q.3A RATED CAPACITY" V41 "Q.3B(1) LIMIT:# INMATES" V42 "Q.3B(2) MAXIM:# INMATES" V43 "Q.3C(1) SEPARATE:JUV/ADT" V44 "Q.3C(2) # JUV SEPARATED" V45 "Q.3D(1) SEPARATE:FEM/MAL" V46 "Q.3D(2) # FEM SEPARATED" V47 "Q.4A(1) NEWLY CONST/CONV" V48 "YEAR FACILITY OPENED" V49 "Q.4B RENOVATION PLANS" V50 "Q.4B1B NEW JAIL:YEAR" V51 "Q.4B1C NEW JAIL:# BEDS" V52 "Q.4B1D NEW JAIL:COST/BED" V53 "Q.4B2B REV INCRS:YEAR" V54 "Q.4B2C REV INCRS:# BEDS" V55 "Q.4B2D REV INCRS:COST/BD" V56 "Q.4B3B REV DECRS:YEAR" V57 "Q.4B3C REV DECRS:# BEDS" V58 "Q.4B4B CLOSE PART:YEAR" V59 "Q.4B4C CLOSE PART:# BEDS" V60 "Q.4B5B NO CHNGE CAP:YEAR" V61 "Q.4B6B CLOSE FACLTY:YEAR" V62 "Q.4B6C CLOSE FACLTY:# BD" V63 "Q.5A11 TOT INMAT:TOTAL" V64 "Q.5A12 TOT INMAT:ADT MA" V65 "Q.5A13 TOT INMAT:ADT FE" V66 "Q.5A14 TOT INMAT:JUV MA" V67 "Q.5A15 TOT INMAT:JUV FE" V68 "Q.5A2A1 AWT TRIAL:TOTAL" V69 "Q.5A2A2 AWT TRIAL:ADT MA" V70 "Q.5A2A3 AWT TRIAL:ADT FE" V71 "Q.5A2A4 AWT TRIAL:JUV MA" V72 "Q.5A2A5 AWT TRIAL:JUV FE" V73 "Q.5A2B1 AWT SENTN:TOTAL" V74 "Q.5A2B2 AWT SENTN:ADT MA" V75 "Q.5A2B3 AWT SENTN:ADT FE" V76 "Q.5A2B4 AWT SENTN:JUV MA" V77 "Q.5A2B5 AWT SENTN:JUV FE" V78 "Q.5A2C1 SERV SENT:TOTAL" V79 "Q.5A2C2 SERV SENT:ADT MA" V80 "Q.5A2C3 SERV SENT:ADT FE" V81 "Q.5A2C4 SERV SENT:JUV MA" V82 "Q.5A2C5 SERV SENT:JUV FE" V83 "Q.5A2D1 TECH VIOL:TOTAL" V84 "Q.5A2D2 TECH VIOL:ADT MA" V85 "Q.5A2D3 TECH VIOL:ADT FE" V86 "Q.5A2D4 TECH VIOL:JUV MA" V87 "Q.5A2D5 TECH VIOL:JUV FE" V88 "Q.5A2E1 JUV AUTHR:TOTAL" V89 "Q.5A2E4 JUV AUTHR:JUV MA" V90 "Q.5A2E5 JUV AUTHR:JUV FE" V91 "Q.5A2F1 OTHR INMT:TOTAL" V92 "Q.5A2F2 OTHR INMT:ADT MA" V93 "Q.5A2F3 OTHR INMT:ADT FE" V94 "Q.5A2F4 OTHR INMT:JUV MA" V95 "Q.5A2F5 OTHR INMT:JUV FE" V96 "Q.5B1A TOT HLD:FED ALIEN" V97 "Q.5B1B TOT HLD:FED OTHER" V98 "Q.5B1C TOT HLD:STATE" V99 "Q.5B1D TOT HLD:CNTY/CITY" V100 "Q.5B2AA OVRCRD:FED ALIEN" V101 "Q.5B2AB OVRCRD:FED OTHER" V102 "Q.5B2AC OVRCRD:STATE" V103 "Q.5B2AD OVRCRD:CNTY/CITY" V104 "Q.5B2B1A TRANS:FED ALIEN" V105 "Q.5B2B1B TRANS:FED OTHER" V106 "Q.5B2B1C TRANS:STATE" V107 "Q.5B2B1D TRANS:CNTY/CITY" V108 "Q.5B2B2A OTHER:FED ALIEN" V109 "Q.5B2B2B OTHER:FED OTHER" V110 "Q.5B2B2C OTHER:STATE" V111 "Q.5B2B2D OTHER:CNTY/CITY" V112 "Q.5C1A AV DAY POP:TOTAL" V113 "Q.5C1B AV DAY POP:ADT MA" V114 "Q.5C1C AV DAY POP:ADT FE" V115 "Q.5C1D AV DAY POP:JUV MA" V116 "Q.5C1E AV DAY POP:JUV FE" V117 "Q.5C2(A) ADP LARGR WKEND" V118 "Q.5C2(B) AV DY POP:WKEND" V119 "Q.5D1A # ADMITTED:TOTAL" V120 "Q.5D1B # ADMITTED:ADT MA" V121 "Q.5D1C # ADMITTED:ADT FE" V122 "Q.5D1D # ADMITTED:JUV MA" V123 "Q.5D1E # ADMITTED:JUV FE" V124 "Q.5D2A # DISCHRGD:TOTAL" V125 "Q.5D2B # DISCHRGD:ADT MA" V126 "Q.5D2C # DISCHRGD:ADT FE" V127 "Q.5D2D # DISCHRGD:JUV MA" V128 "Q.5D2E # DISCHRGD:JUV FE" V129 "Q.5E1A DTH-ILLNES:TOTAL" V130 "Q.5E1B DTH-ILLNES:ADT MA" V131 "Q.5E1C DTH-ILLNES:ADT FE" V132 "Q.5E1D DTH-ILLNES:JUV MA" V133 "Q.5E1E DTH-ILLNES:JUV FE" V134 "Q.5E2A DTH-SUICDE:TOTAL" V135 "Q.5E2B DTH-SUICDE:ADT MA" V136 "Q.5E2C DTH-SUICDE:ADT FE" V137 "Q.5E2D DTH-SUICDE:JUV MA" V138 "Q.5E2E DTH-SUICDE:JUV FE" V139 "Q.5E3A DTH-HOM IM:TOTAL" V140 "Q.5E3B DTH-HOM IM:ADT MA" V141 "Q.5E3C DTH-HOM IM:ADT FE" V142 "Q.5E3D DTH-HOM IM:JUV MA" V143 "Q.5E3E DTH-HOM IM:JUV FE" V144 "Q.5E4A DTH-HOM OT:TOTAL" V145 "Q.5E4B DTH-HOM OT:ADT MA" V146 "Q.5E4C DTH-HOM OT:ADT FE" V147 "Q.5E4D DTH-HOM OT:JUV MA" V148 "Q.5E4E DTH-HOM OT:JUV FE" V149 "Q.5E5A DEATH-OTHR:TOTAL" V150 "Q.5E5B DEATH-OTHR:ADT MA" V151 "Q.5E5C DEATH-OTHR:ADT FE" V152 "Q.5E5D DEATH-OTHR:JUV MA" V153 "Q.5E5E DEATH-OTHR:JUV FE" V154 "Q.6A(1) DAILY WRK RELEAS" V155 "Q.6A(2) WORK RELEASE:MAL" V156 "Q.6A(3) WORK RELEASE:FEM" V157 "Q.6B SEP FACLTY:WRK REL" V158 "Q.6C(1) WEEKEND SENTENCE" V159 "Q.6C(2) WKEND SENTNC:MAL" V160 "Q.6C(3) WKEND SENTNC:FEM" V161 "Q.7B2(A)(1) RATD CAP-1" V162 "Q.7B2(B)(1) NOT RATD-1" V163 "Q.7B3(1) # CONF UNITS-1" V164 "Q.7B4(1) FLOOR SPACE-1" V165 "Q.7B5(1) # HRS CONFND-1" V166 "Q.7B6(1) CONF UNT USE-1" V167 "HELD: ADULT/JUV-1" V168 "HELD: MALE/FEMALE-1" V169 "HELD: SENTNC/UNSENTNC-1" V170 "Q.7B8(1) # HELD TODAY-1" V171 "Q.7B2(A)(2) RATD CAP-2" V172 "Q.7B2(B)(2) NOT RATD-2" V173 "Q.7B3(2) # CONF UNITS-2" V174 "Q.7B4(2) FLOOR SPACE-2" V175 "Q.7B5(2) # HRS CONFND-2" V176 "Q.7B6(2) CONF UNT USE-2" V177 "HELD: ADULT/JUV-2" V178 "HELD: MALE/FEMALE-2" V179 "HELD: SENTNC/UNSENTNC-2" V180 "Q.7B8(2) # HELD TODAY-2" V181 "Q.7B2(A)(3) RATD CAP-3" V182 "Q.7B2(B)(3) NOT RATD-3" V183 "Q.7B3(3) # CONF UNITS-3" V184 "Q.7B4(3) FLOOR SPACE-3" V185 "Q.7B5(3) # HRS CONFND-3" V186 "Q.7B6(3) CONF UNT USE-3" V187 "HELD: ADULT/JUV-3" V188 "HELD: MALE/FEMALE-3" V189 "HELD: SENTNC/UNSENTNC-3" V190 "Q.7B8(3) # HELD TODAY-3" V191 "Q.7B2(A)(4) RATD CAP-4" V192 "Q.7B2(B)(4) NOT RATD-4" V193 "Q.7B3(4) # CONF UNITS-4" V194 "Q.7B4(4) FLOOR SPACE-4" V195 "Q.7B5(4) # HRS CONFND-4" V196 "Q.7B6(4) CONF UNT USE-4" V197 "HELD: ADULT/JUV-4" V198 "HELD: MALE/FEMALE-4" V199 "HELD: SENTNC/UNSENTNC-4" V200 "Q.7B8(4) # HELD TODAY-4" V201 "Q.7B2(A)(5) RATD CAP-5" V202 "Q.7B2(B)(5) NOT RATD-5" V203 "Q.7B3(5) # CONF UNITS-5" V204 "Q.7B4(5) FLOOR SPACE-5" V205 "Q.7B5(5) # HRS CONFND-5" V206 "Q.7B6(5) CONF UNT USE-5" V207 "HELD: ADULT/JUV-5" V208 "HELD: MALE/FEMALE-5" V209 "HELD: SENTNC/UNSENTNC-5" V210 "Q.7B8(5) # HELD TODAY-5" V211 "Q.7B2(A)(6) RATD CAP-6" V212 "Q.7B2(B)(6) NOT RATD-6" V213 "Q.7B3(6) # CONF UNITS-6" V214 "Q.7B4(6) FLOOR SPACE-6" V215 "Q.7B5(6) # HRS CONFND-6" V216 "Q.7B6(6) CONF UNT USE-6" V217 "HELD: ADULT/JUV-6" V218 "HELD: MALE/FEMALE-6" V219 "HELD: SENTNC/UNSENTNC-6" V220 "Q.7B8(6) # HELD TODAY-6" V221 "Q.7B2(A)(7) RATD CAP-7" V222 "Q.7B2(B)(7) NOT RATD-7" V223 "Q.7B3(7) # CONF UNITS-7" V224 "Q.7B4(7) FLOOR SPACE-7" V225 "Q.7B5(7) # HRS CONFND-7" V226 "Q.7B6(7) CONF UNT USE-7" V227 "HELD: ADULT/JUV-7" V228 "HELD: MALE/FEMALE-7" V229 "HELD: SENTNC/UNSENTNC-7" V230 "Q.7B8(7) # HELD TODAY-7" V231 "Q.7B2(A)(8) RATD CAP-8" V232 "Q.7B2(B)(8) NOT RATD-8" V233 "Q.7B3(8) # CONF UNITS-8" V234 "Q.7B4(8) FLOOR SPACE-8" V235 "Q.7B5(8) # HRS CONFND-8" V236 "Q.7B6(8) CONF UNT USE-8" V237 "HELD: ADULT/JUV-8" V238 "HELD: MALE/FEMALE-8" V239 "HELD: SENTNC/UNSENTNC-8" V240 "Q.7B8(8) # HELD TODAY-8" V241 "Q.7B2(A)(9) RATD CAP-9" V242 "Q.7B2(B)(9) NOT RATD-9" V243 "Q.7B3(9) # CONF UNITS-9" V244 "Q.7B4(9) FLOOR SPACE-9" V245 "Q.7B5(9) # HRS CONFND-9" V246 "Q.7B6(9) CONF UNT USE-9" V247 "HELD: ADULT/JUV-9" V248 "HELD: MALE/FEMALE-9" V249 "HELD: SENTNC/UNSENTNC-9" V250 "Q.7B8(9) # HELD TODAY-9" V251 "Q.7B2(A)(10) RATD CAP-10" V252 "Q.7B2(B)(10) NOT RATD-10" V253 "Q.7B3(10) # CONF UNTS-10" V254 "Q.7B4(10) FLOOR SPACE-10" V255 "Q.7B5(10) # HRS CONFD-10" V256 "Q.7B6(10) CONF UT USE-10" V257 "HELD: ADULT/JUV-10" V258 "HELD: MALE/FEMALE-10" V259 "HELD: SENTNC/UNSENTNC-10" V260 "Q.7B8(10) # HLD TODAY-10" V261 "Q.7B2(A)(11) RATD CAP-11" V262 "Q.7B2(B)(11) NOT RATD-11" V263 "Q.7B3(11) # CONF UNTS-11" V264 "Q.7B4(11) FLOOR SPACE-11" V265 "Q.7B5(11) # HRS CONFD-11" V266 "Q.7B6(11) CONF UT USE-11" V267 "HELD: ADULT/JUV-11" V268 "HELD: MALE/FEMALE-11" V269 "HELD: SENTNC/UNSENTNC-11" V270 "Q.7B8(11) # HLD TODAY-11" V271 "Q.7B2(A)(12) RATD CAP-12" V272 "Q.7B2(B)(12) NOT RATD-12" V273 "Q.7B3(12) # CONF UNTS-12" V274 "Q.7B4(12) FLOOR SPACE-12" V275 "Q.7B5(12) # HRS CONFD-12" V276 "Q.7B6(12) CONF UT USE-12" V277 "HELD: ADULT/JUV-12" V278 "HELD: MALE/FEMALE-12" V279 "HELD: SENTNC/UNSENTNC-12" V280 "Q.7B8(12) # HLD TODAY-12" V281 "Q.7B2(A)(13) RATD CAP-13" V282 "Q.7B2(B)(13) NOT RATD-13" V283 "Q.7B3(13) # CONF UNTS-13" V284 "Q.7B4(13) FLOOR SPACE-13" V285 "Q.7B5(13) # HRS CONFD-13" V286 "Q.7B6(13) CONF UT USE-13" V287 "HELD: ADULT/JUV-13" V288 "HELD: MALE/FEMALE-13" V289 "HELD: SENTNC/UNSENTNC-13" V290 "Q.7B8(13) # HLD TODAY-13" V291 "Q.7B2(A)(14) RATD CAP-14" V292 "Q.7B2(B)(14) NOT RATD-14" V293 "Q.7B3(14) # CONF UNTS-14" V294 "Q.7B4(14) FLOOR SPACE-14" V295 "Q.7B5(14) # HRS CONFD-14" V296 "Q.7B6(14) CONF UT USE-14" V297 "HELD: ADULT/JUV-14" V298 "HELD: MALE/FEMALE-14" V299 "HELD: SENTNC/UNSENTNC-14" V300 "Q.7B8(14) # HLD TODAY-14" V301 "Q.7B2(A)(15) RATD CAP-15" V302 "Q.7B2(B)(15) NOT RATD-15" V303 "Q.7B3(15) # CONF UNTS-15" V304 "Q.7B4(15) FLOOR SPACE-15" V305 "Q.7B5(15) # HRS CONFD-15" V306 "Q.7B6(15) CONF UT USE-15" V307 "HELD: ADULT/JUV-15" V308 "HELD: MALE/FEMALE-15" V309 "HELD: SENTNC/UNSENTNC-15" V310 "Q.7B8(15) # HLD TODAY-15" V311 "Q.7B2(A)(16) RATD CAP-16" V312 "Q.7B2(B)(16) NOT RATD-16" V313 "Q.7B3(16) # CONF UNTS-16" V314 "Q.7B4(16) FLOOR SPACE-16" V315 "Q.7B5(16) # HRS CONFD-16" V316 "Q.7B6(16) CONF UT USE-16" V317 "HELD: ADULT/JUV-16" V318 "HELD: MALE/FEMALE-16" V319 "HELD: SENTNC/UNSENTNC-16" V320 "Q.7B8(16) # HLD TODAY-16" V321 "Q.7B2(A)(17) RATD CAP-17" V322 "Q.7B2(B)(17) NOT RATD-17" V323 "Q.7B3(17) # CONF UNTS-17" V324 "Q.7B4(17) FLOOR SPACE-17" V325 "Q.7B5(17) # HRS CONFD-17" V326 "Q.7B6(17) CONF UT USE-17" V327 "HELD: ADULT/JUV-17" V328 "HELD: MALE/FEMALE-17" V329 "HELD: SENTNC/UNSENTNC-17" V330 "Q.7B8(17) # HLD TODAY-17" V331 "Q.7B2(A)(18) RATD CAP-18" V332 "Q.7B2(B)(18) NOT RATD-18" V333 "Q.7B3(18) # CONF UNTS-18" V334 "Q.7B4(18) FLOOR SPACE-18" V335 "Q.7B5(18) # HRS CONFD-18" V336 "Q.7B6(18) CONF UT USE-18" V337 "HELD: ADULT/JUV-18" V338 "HELD: MALE/FEMALE-18" V339 "HELD: SENTNC/UNSENTNC-18" V340 "Q.7B8(18) # HLD TODAY-18" V341 "Q.7B2(A)(19) RATD CAP-19" V342 "Q.7B2(B)(19) NOT RATD-19" V343 "Q.7B3(19) # CONF UNTS-19" V344 "Q.7B4(19) FLOOR SPACE-19" V345 "Q.7B5(19) # HRS CONFD-19" V346 "Q.7B6(19) CONF UT USE-19" V347 "HELD: ADULT/JUV-19" V348 "HELD: MALE/FEMALE-19" V349 "HELD: SENTNC/UNSENTNC-19" V350 "Q.7B8(19) # HLD TODAY-19" V351 "Q.7B2(A)(20) RATD CAP-20" V352 "Q.7B2(B)(20) NOT RATD-20" V353 "Q.7B3(20) # CONF UNTS-20" V354 "Q.7B4(20) FLOOR SPACE-20" V355 "Q.7B5(20) # HRS CONFD-20" V356 "Q.7B6(20) CONF UT USE-20" V357 "HELD: ADULT/JUV-20" V358 "HELD: MALE/FEMALE-20" V359 "HELD: SENTNC/UNSENTNC-20" V360 "Q.7B8(20) # HLD TODAY-20" V361 "Q.7B9 TOTAL # HELD TODAY" V362 "Q.8A1 TOTAL:PAYROLL FULL" V363 "Q.8A2 TOTAL:PAYROLL PART" V364 "Q.8A3 TOTAL:NONPAYRL FUL" V365 "Q.8A4 TOTAL:NONPAYRL PRT" V366 "Q.8A5 TOTAL:COMM VOL FUL" V367 "Q.8A6 TOTAL:COMM VOL PRT" V368 "Q.8B1 ADMIN:PAYROLL FULL" V369 "Q.8B2 ADMIN:PAYROLL PART" V370 "Q.8B3 ADMIN:NONPAYRL FUL" V371 "Q.8B4 ADMIN:NONPAYRL PRT" V372 "Q.8B5 ADMIN:COMM VOL FUL" V373 "Q.8B6 ADMIN:COMM VOL PRT" V374 "Q.8C1 C OFF:PAYROLL FULL" V375 "Q.8C2 C OFF:PAYROLL PART" V376 "Q.8C3 C OFF:NONPAYRL FUL" V377 "Q.8C4 C OFF:NONPAYRL PRT" V378 "Q.8C5 C OFF:COMM VOL FUL" V379 "Q.8C6 C OFF:COMM VOL PRT" V380 "Q.8D1 CLERC:PAYROLL FULL" V381 "Q.8D2 CLERC:PAYROLL PART" V382 "Q.8D3 CLERC:NONPAYRL FUL" V383 "Q.8D4 CLERC:NONPAYRL PRT" V384 "Q.8D5 CLERC:COMM VOL FUL" V385 "Q.8D6 CLERC:COMM VOL PRT" V386 "Q.8E1 EDUCA:PAYROLL FULL" V387 "Q.8E2 EDUCA:PAYROLL PART" V388 "Q.8E3 EDUCA:NONPAYRL FUL" V389 "Q.8E4 EDUCA:NONPAYRL PRT" V390 "Q.8E5 EDUCA:COMM VOL FUL" V391 "Q.8E6 EDUCA:COMM VOL PRT" V392 "Q.8F1 PROFS:PAYROLL FULL" V393 "Q.8F2 PROFS:PAYROLL PART" V394 "Q.8F3 PROFS:NONPAYRL FUL" V395 "Q.8F4 PROFS:NONPAYRL PRT" V396 "Q.8F5 PROFS:COMM VOL FUL" V397 "Q.8F6 PROFS:COMM VOL PRT" V398 "Q.8G1 OTHER:PAYROLL FULL" V399 "Q.8G2 OTHER:PAYROLL PART" V400 "Q.8G3 OTHER:NONPAYRL FUL" V401 "Q.8G4 OTHER:NONPAYRL PRT" V402 "Q.8G5 OTHER:COMM VOL FUL" V403 "Q.8G6 OTHER:COMM VOL PRT" V404 "Q.9(A) FISCAL YR:BEG MON" V405 "Q.9(B) FISCAL YR:BEG DAY" V406 "Q.9(C) FISCAL YR:BEG YR" V407 "Q.9(D) FISCAL YR:END MON" V408 "Q.9(E) FISCAL YR:END DAY" V409 "Q.9(F) FISCAL YR:END YR" V410 "Q.9A1 OP EXPENS:SALARIES" V411 "Q.9A2 OP EXPENS:OTHER" V412 "Q.9B1 CAP EXPEN:CONSTRCT" V413 "Q.9B2 CAP EXPEN:EQUIPMNT" V414 "Q.9B3 CAP EXPEN:OTHER" V415 "Q.10A1A SCREEN:NONE UNST" V416 "Q.10A1B SCREEN:NONE SENT" V417 "Q.10A2A SCREEN:PHYS UNST" V418 "Q.10A2B SCREEN:PHYS SENT" V419 "Q.10A3A SCREEN:MENT UNST" V420 "Q.10A3B SCREEN:MENT SENT" V421 "Q.10A4A SCREEN:SUIC UNST" V422 "Q.10A4B SCREEN:SUIC SENT" V423 "Q.10A5A SCREEN:ALCO UNST" V424 "Q.10A5B SCREEN:ALCO SENT" V425 "Q.10A6A SCREEN:DRUG UNST" V426 "Q.10A6B SCREEN:DRUG SENT" V427 "Q.10A7A SCREEN:OTHR UNST" V428 "Q.10A7B SCREEN:OTHR SENT" V429 "TYPE OF UNSENT GVN PHYSC" V430 "TYPE OF SENTNC GVN PHYSC" V431 "Q.10B5AA LAB EX:URN UNST" V432 "Q.10B5AB LAB EX:URN SENT" V433 "Q.10B5BA LAB EX:BLD UNST" V434 "Q.10B5BB LAB EX:BLD SENT" V435 "Q.10B5CA LAB EX:CHST UNS" V436 "Q.10B5CB LAB EX:CHST SEN" V437 "UNSENT: TYPE OF EXERCISE" V438 "SENTNC: TYPE OF EXERCISE" V439 "Q.10D1 MEDICAL FAC:NONE" V440 "Q.10D2 MED FAC:INF W/O B" V441 "Q.10D3 MED FAC:INF W BED" V442 "Q.10D4 MEDICAL FAC:DETOX" V443 "Q.10D5 MEDICAL FAC:PSYCH" V444 "Q.10D6 MEDICAL FAC:OTHER" V445 "AVAILABILITY OF DOCTORS" V446 "AVAILABILITY OF NURSES" V447 "AVAILABILITY OF PARAMED" V448 "MNTL HLTH CARE AVAILBTY" V449 "Q.10F # FIRES NEED F DPT" V450 "Q.10G FACLTY:COURT ORDER" V451 "Q.10H FACLTY:REGNL JAIL" V452 "TOTAL NUMBER OF BEDS" . * SPSS MISSING VALUES COMMAND. MISSING VALUES V12 (0000009) V42 (-000001) V44 (-000001) V46 (-000001) V50 (-000001) V51 (-000001) V52 (-000001) V53 (-000001) V54 (-000001) V55 (-000001) V56 (-000001) V57 (-000001) V58 (-000001) V59 (-000001) V60 (-000001) V61 (-000001) V62 (-000001) V64 (-000001) V65 (-000001) V66 (-000001) V67 (-000001) V68 (-000001) V69 (-000001) V70 (-000001) V71 (-000001) V72 (-000001) V73 (-000001) V74 (-000001) V75 (-000001) V76 (-000001) V77 (-000001) V78 (-000001) V79 (-000001) V80 (-000001) V81 (-000001) V82 (-000001) V83 (-000001) V84 (-000001) V85 (-000001) V86 (-000001) V87 (-000001) V88 (-000001) V89 (-000001) V90 (-000001) V91 (-000001) V92 (-000001) V93 (-000001) V94 (-000001) V95 (-000001) V96 (-000001) V97 (-000001) V98 (-000001) V99 (-000001) V100 (-000001) V101 (-000001) V102 (-000001) V103 (-000001) V104 (-000001) V105 (-000001) V106 (-000001) V107 (-000001) V108 (-000001) V109 (-000001) V110 (-000001) V111 (-000001) V113 (-000001) V114 (-000001) V115 (-000001) V116 (-000001) V120 (-000001) V121 (-000001) V122 (-000001) V123 (-000001) V125 (-000001) V126 (-000001) V127 (-000001) V128 (-000001) V129 (-000001) V130 (-000001) V131 (-000001) V132 (-000001) V133 (-000001) V134 (-000001) V135 (-000001) V136 (-000001) V137 (-000001) V138 (-000001) V139 (-000001) V140 (-000001) V141 (-000001) V142 (-000001) V143 (-000001) V144 (-000001) V145 (-000001) V146 (-000001) V147 (-000001) V148 (-000001) V149 (-000001) V150 (-000001) V151 (-000001) V152 (-000001) V153 (-000001) V155 (-000001) V156 (-000001) V159 (-000001) V160 (-000001) V161 (0000000) V162 (0000000) V163 (0000000) V164 (0000000) V165 (0000000) V166 (0000000) V167 (0000000) V168 (0000000) V169 (0000000) V170 (0000000) V171 (0000000) V172 (0000000) V173 (0000000) V174 (0000000) V175 (0000000) V176 (0000000) V177 (0000000) V178 (0000000) V179 (0000000) V180 (0000000) V181 (0000000) V182 (0000000) V183 (0000000) V184 (0000000) V185 (0000000) V186 (0000000) V187 (0000000) V188 (0000000) V189 (0000000) V190 (0000000) V191 (0000000) V192 (0000000) V193 (0000000) V194 (0000000) V195 (0000000) V196 (0000000) V197 (0000000) V198 (0000000) V199 (0000000) V200 (0000000) V201 (0000000) V202 (0000000) V203 (0000000) V204 (0000000) V205 (0000000) V206 (0000000) V207 (0000000) V208 (0000000) V209 (0000000) V210 (0000000) V211 (0000000) V212 (0000000) V213 (0000000) V214 (0000000) V215 (0000000) V216 (0000000) V217 (0000000) V218 (0000000) V219 (0000000) V220 (0000000) V221 (0000000) V222 (0000000) V223 (0000000) V224 (0000000) V225 (0000000) V226 (0000000) V227 (0000000) V228 (0000000) V229 (0000000) V230 (0000000) V231 (0000000) V232 (0000000) V233 (0000000) V234 (0000000) V235 (0000000) V236 (0000000) V237 (0000000) V238 (0000000) V239 (0000000) V240 (0000000) V241 (0000000) V242 (0000000) V243 (0000000) V244 (0000000) V245 (0000000) V246 (0000000) V247 (0000000) V248 (0000000) V249 (0000000) V250 (0000000) V251 (0000000) V252 (0000000) V253 (0000000) V254 (0000000) V255 (0000000) V256 (0000000) V257 (0000000) V258 (0000000) V259 (0000000) V260 (0000000) V261 (0000000) V262 (0000000) V263 (0000000) V264 (0000000) V265 (0000000) V266 (0000000) V267 (0000000) V268 (0000000) V269 (0000000) V270 (0000000) V271 (0000000) V272 (0000000) V273 (0000000) V274 (0000000) V275 (0000000) V276 (0000000) V277 (0000000) V278 (0000000) V279 (0000000) V280 (0000000) V281 (0000000) V282 (0000000) V283 (0000000) V284 (0000000) V285 (0000000) V286 (0000000) V287 (0000000) V288 (0000000) V289 (0000000) V290 (0000000) V291 (0000000) V292 (0000000) V293 (0000000) V294 (0000000) V295 (0000000) V296 (0000000) V297 (0000000) V298 (0000000) V299 (0000000) V300 (0000000) V301 (0000000) V302 (0000000) V303 (0000000) V304 (0000000) V305 (0000000) V306 (0000000) V307 (0000000) V308 (0000000) V309 (0000000) V310 (0000000) V311 (0000000) V312 (0000000) V313 (0000000) V314 (0000000) V315 (0000000) V316 (0000000) V317 (0000000) V318 (0000000) V319 (0000000) V320 (0000000) V321 (0000000) V322 (0000000) V323 (0000000) V324 (0000000) V325 (0000000) V326 (0000000) V327 (0000000) V328 (0000000) V329 (0000000) V330 (0000000) V331 (0000000) V332 (0000000) V333 (0000000) V334 (0000000) V335 (0000000) V336 (0000000) V337 (0000000) V338 (0000000) V339 (0000000) V340 (0000000) V341 (0000000) V342 (0000000) V343 (0000000) V344 (0000000) V345 (0000000) V346 (0000000) V347 (0000000) V348 (0000000) V349 (0000000) V350 (0000000) V351 (0000000) V352 (0000000) V353 (0000000) V354 (0000000) V355 (0000000) V356 (0000000) V357 (0000000) V358 (0000000) V359 (0000000) V360 (0000000) V361 (0000000) V362 (-000001) V363 (-000001) V364 (-000001) V365 (-000001) V366 (-000001) V367 (-000001) V368 (-000001) V369 (-000001) V370 (-000001) V371 (-000001) V372 (-000001) V373 (-000001) V374 (-000001) V375 (-000001) V376 (-000001) V377 (-000001) V378 (-000001) V379 (-000001) V380 (-000001) V381 (-000001) V382 (-000001) V383 (-000001) V384 (-000001) V385 (-000001) V386 (-000001) V387 (-000001) V388 (-000001) V389 (-000001) V390 (-000001) V391 (-000001) V392 (-000001) V393 (-000001) V394 (-000001) V395 (-000001) V396 (-000001) V397 (-000001) V398 (-000001) V399 (-000001) V400 (-000001) V401 (-000001) V402 (-000001) V403 (-000001) V410 (-000001) V411 (-000001) V412 (-000001) V413 (-000001) V414 (-000001) V429 (0000009) V430 (0000009) V449 (-000001) . **************************************************************************** ** CREATING THE ID **************************************************************************** ** 1983 JAIL **************************************************************************** NUMERIC id (f14.0). COMPUTE id = v11 * 1 + v15 * 10**1 + v9 * 10**4 + v8 * 10**5 + v7 * 10**8 + v6 * 10**11 + v5 * 10**12. EXECUTE. *** For this project, all I use is the state, the count, the ADP, and a summary of court orders *** So leave the data in order, but create new variables for just those characteristics RECODE v5 (else = copy) into state . RECODE v63 (else = copy) into count. RECODE v112 (else = copy) into ADP. RECODE v41 (1 = 0) (2 = 1) into popcp. RECODE v450 (1 = 0) (2 = 1) into ord_o. COMPUTE ordsm = 0. IF popcp = 1 | ord_o = 1 ordsm = 1. COMPUTE S = 1. VARIABLE LABELS ord_o "non-population cap order" ordsm "Population cap or other order" S "In 1983 Census" . VALUE LABELS state 01 "Alabama" 02 "Alaska" 03 "Arizona" 04 "Arkansas" 05 "California" 06 "Colorado" 07 "Connecticut" 08 "Delaware" 09 "District of Columbia" 10 "Florida" 11 "Georgia" 12 "Hawaii" 13 "Idaho" 14 "Illinois" 15 "Indiana" 16 "Iowa" 17 "Kansas" 18 "Kentucky" 19 "Louisiana" 20 "Maine" 21 "Maryland" 22 "Massachusetts" 23 "Michigan" 24 "Minnesota" 25 "Mississippi" 26 "Missouri" 27 "Montana" 28 "Nebraska" 29 "Nevada" 30 "New Hampshire" 31 "New Jersey" 32 "New Mexico" 33 "New York" 34 "North Carolina" 35 "North Dakota" 36 "Ohio" 37 "Oklahoma" 38 "Oregon" 39 "Pennsylvania" 40 "Rhode Island" 41 "South Carolina" 42 "South Dakota" 43 "Tennessee" 44 "Texas" 45 "Utah" 46 "Vermont" 47 "Virginia" 48 "Washington" 49 "West Virginia" 50 "Wisconsin" 51 "Wyoming" / v41 v450 1 "No (1)" 2 "Yes (2)" / popcp ord_o ordsm S 0 "No (0)" 1 "Yes (1)" . MATCH FILES FILE = * /KEEP id S state count ADP popcp ord_o ordsm ALL. SAVE OUTFILE = !Path1+"Jail1983.sav" . *** Add "_83" to each variable name *** *** First, each variable name needs to be five characters or less. FLIP. STRING newname(A8). COMPUTE newname=CONCAT(RTRIM(case_lbl),'_83'). WRITE OUTFILE='C:\temp\rename.sps' / 'RENAME VARIABLE ('case_lbl'='newname').'. EXECUTE. GET FILE = !Path1+"Jail1983.sav" . INCLUDE 'C:\temp\rename.sps'. RENAME VARIABLE (id_83 = id). STRING strid strid2 (a14). NUMERIC id99 (f14.0). COMPUTE strid=STRING(id,f14.0). COMPUTE strid2 = CONCAT(SUBSTR(strid,1,9),'0',SUBSTR(strid,11,4)). COMPUTE id99 = NUMBER(strid2,f14.0). MATCH FILES FILE = * /KEEP id id99 strid strid2 ALL. SAVE OUTFILE = !Path1+"Jail1983.sav" .