*** 1995 Prison Census *** For this project, all I use is 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. *** First, open up the data [This is just from the ICPSR data definition statement] *-------------------------------------------------------------------------* | SPSS DATA DEFINITION STATEMENTS FOR ICPSR 6953 | | | | CENSUS OF STATE AND FEDERAL ADULT CORRECTIONAL FACILITIES, 1995 | | First ICPSR edition | | April, 2003 | | | | This SPSS setup file contains the following statements: | | | | DATA LIST: Specifies the input data file to be read and assigns the | | name, type, decimal specification (if any), and identifies variable | | beginning and ending column locations. Users must replace | | "file-specification" with a complete statement of the location of the | | data file. | | | | VARIABLE LABELS: Assigns descriptive labels to variables. Variable | | labels and variable names may be identical for certain variables. | | | | VALUE LABELS: Assigns descriptive labels to codes in the data file. | | Value labels may not be present for all variables in the data file. | | | | MISSING VALUES: Declares user-defined missing values. These values | | can be treated specially in data transformations, statistical | | calculations, and case selection. Missing values may not be present | | for all variables in the data file. | | | | NOTE: Users should modify this SPSS setup to suit their specific | | needs. MISSING VALUES section has been marked by SPSS comment | | statements. To include this section in a final SPSS setup, users | | should remove the SPSS comment statements. | *-------------------------------------------------------------------------. * SPSS FILE HANDLE, DATA LIST COMMANDS. FILE HANDLE DATA / NAME="D:/TechnicalAppendix/CorrectionalCensuses/da6953" LRECL=1189. DATA LIST FILE=DATA / V1 1-2 V2 3-3 V3 4-6 V4 7-9 V5 10-11 V6 12-16 V7 17-61 (A) V8 62-106 (A) V9 107-138 (A) V10 139-140 (A) V11 141-149 V12 150-159 V13 160-160 V14 161-161 V15 162-162 V16 163-163 V17 164-164 V18 165-167 V19 168-168 V20 169-169 V21 170-172 V22 173-173 V23 174-174 V24 175-175 V25 176-176 V26 177-177 V27 178-178 V28 179-179 V29 180-180 V30 181-181 V31 182-182 V32 183-228 (A) V33 229-229 V34 230-235 V35 236-236 V36 237-242 V37 243-243 V38 244-246 V39 247-247 V40 248-248 V41 249-249 V42 250-250 V43 251-251 V44 252-257 V45 258-258 V46 259-264 V47 265-265 V48 266-266 V49 267-272 V50 273-273 V51 274-274 V52 275-275 V53 276-276 V54 277-277 V55 278-278 V56 279-279 V57 280-280 V58 281-281 V59 282-282 V60 283-283 V61 284-284 V62 285-285 V63 286-286 V64 287-287 V65 288-288 V66 289-289 V67 290-290 V68 291-291 V69 292-337 (A) V70 338-338 V71 339-344 V72 345-345 V73 346-351 V74 352-352 V75 353-358 V76 359-359 V77 360-365 V78 366-366 V79 367-372 V80 373-373 V81 374-379 V82 380-380 V83 381-386 V84 387-387 V85 388-393 V86 394-394 V87 395-400 V88 401-401 V89 402-407 V90 408-408 V91 409-414 V92 415-415 V93 416-421 V94 422-422 V95 423-428 V96 429-429 V97 430-435 V98 436-436 V99 437-442 V100 443-443 V101 444-449 V102 450-450 V103 451-456 V104 457-457 V105 458-463 V106 464-464 V107 465-470 V108 471-471 V109 472-477 V110 478-478 V111 479-484 (A) V112 485-485 V113 486-491 V114 492-492 V115 493-498 V116 499-499 V117 500-505 V118 506-506 V119 507-512 V120 513-513 V121 514-519 V122 520-520 V123 521-526 V124 527-527 V125 528-533 V126 534-534 V127 535-540 V128 541-541 V129 542-547 V130 548-548 V131 549-554 V132 555-555 V133 556-561 V134 562-562 V135 563-568 (A) V136 569-569 V137 570-575 V138 576-576 V139 577-582 V140 583-583 V141 584-589 V142 590-590 V143 591-596 V144 597-597 V145 598-603 V146 604-604 V147 605-610 V148 611-611 V149 612-617 V150 618-618 V151 619-664 (A) V152 665-670 V153 671-671 V154 672-677 V155 678-678 V156 679-684 V157 685-685 V158 686-691 V159 692-692 V160 693-698 V161 699-699 V162 700-705 V163 706-706 V164 707-712 V165 713-713 V166 714-719 V167 720-720 V168 721-726 V169 727-727 V170 728-733 V171 734-734 V172 735-740 V173 741-741 V174 742-747 V175 748-748 V176 749-754 V177 755-755 V178 756-761 V179 762-762 V180 763-768 V181 769-769 V182 770-815 (A) V183 816-821 V184 822-822 V185 823-828 V186 829-829 V187 830-830 V188 831-831 V189 832-832 V190 833-833 V191 834-834 V192 835-880 (A) V193 881-881 V194 882-887 V195 888-888 V196 889-889 V197 890-890 V198 891-891 V199 892-892 V200 893-893 V201 894-894 V202 895-895 V203 896-901 V204 902-902 V205 903-903 V206 904-904 V207 905-905 V208 906-906 V209 907-907 V210 908-908 V211 909-909 V212 910-955 (A) V213 956-956 V214 957-957 V215 958-963 V216 964-964 V217 965-965 V218 966-971 V219 972-972 V220 973-973 V221 974-979 V222 980-980 V223 981-981 V224 982-987 V225 988-988 V226 989-994 V227 995-995 V228 996-1001 V229 1002-1002 V230 1003-1008 V231 1009-1009 V232 1010-1015 V233 1016-1016 V234 1017-1022 V235 1023-1023 V236 1024-1029 V237 1030-1030 V238 1031-1076 (A) V239 1077-1082 V240 1083-1083 V241 1084-1084 V242 1085-1090 V243 1091-1091 V244 1092-1092 V245 1093-1098 V246 1099-1099 V247 1100-1100 V248 1101-1106 V249 1107-1107 V250 1108-1108 V251 1109-1114 V252 1115-1115 V253 1116-1116 V254 1117-1122 V255 1123-1123 V256 1124-1124 V257 1125-1125 V258 1126-1131 V259 1132-1132 V260 1133-1133 V261 1134-1179 (A) V262 1180-1180 V263 1181-1183 V264 1184-1187 V265 1188-1188 V266 1189-1189. * SPSS VARIABLE LABELS COMMAND. VARIABLE LABELS V1 "STATE" V2 "TYPE OF GOVERNMENT" V3 "COUNTY CODE" V4 "UNIT ID (CITY CODE WITHIN COUNTY)" V5 "SECTOR" V6 "UNIQUE NUMBER" V7 "NAME OF AGENCY" V8 "ADDRESS" V9 "CITY" V10 "STATE ABBREVIATION" V11 "ZIP CODE" V12 "CENSUS USE ONLY" V13 "WHO OPERATES FACILITY" V14 "PERCENTAGE ALLOWED TO DEPART" V15 "SEX OF INMATES HOUSED" V16 "PHYSICAL SECURITY" V17 "SINGLE OCCUPANCY CELLS" V18 "PERCENTAGE - SINGLE OCCUPANCY" V19 "SINGLE OCCUPANCY FLAG" V20 "MULTIPLE OCCUPANCY CELLS" V21 "PERCENTAGE - MULTIPLE OCCUPANCY" V22 "MULTIPLE OCCUPANCY FLAG" V23 "FUNCTION- GENERAL ADULT POP" V24 "FUNCTION- BOOT CAMP" V25 "FUNCTION- RECEP,DIAGNOSIS,CLASS" V26 "FUNCTION- MEDICAL TREAT/HOSPITAL" V27 "FUNCTION- ALCOHOL/DRUG TREATMENT" V28 "FUNCTION- YOUTHFUL OFFENDERS" V29 "FUNCTION- WORK RELEASE/PRERELEASE" V30 "FUNCTION- FOR PERSONS RETURNED" V31 "FUNCTION- OTHER" V32 "FUNCTION - OTHER (SPECIFY)" V33 "FUNCTION-CATEGORY TO LARGEST #" V34 "RATED CAPACITY" V35 "RATED CAPACITY FLAG" V36 "DESIGN CAPACITY" V37 "DESIGN CAPACITY FLAG" V38 "YEAR OF ORIGINAL CONSTRUCTION" V39 "PLANS - ADD ON TO FACILITY" V40 "PLANS - CLOSE THIS FACILITY" V41 "PLANS - RENOVATE EXISTING SPACE" V42 "PLANS - NO CHANGE PLANNED" V43 "NET EFFECT - OF PLANNED CHANGE" V44 "INCREASE - NUMBER OF BEDS" V45 "INCREASE - NUMBER OF BEDS FLAG" V46 "DECREASE - NUMBER OF BEDS" V47 "DECREASE - NUMBER OF BEDS FLAG" V48 "UNDER COURT ORDER OR CONSENT DECREE" V49 "MAXIMUM NUMBER OF INMATES ALLOWED" V50 "MAXIMUM NUMBER OF INMATES FLAG" V51 "COURT ORDER FOR SPEC CONDITIONS" V52 "COURT ORDER - CROWDING" V53 "COURT ORDER - MEDICAL FACILITIES" V54 "COURT ORDER- ADMIN SEGREGATION" V55 "COURT ORDER - STAFFING" V56 "COURT ORDER - FOOD SERVICE" V57 "COURT ORDER- EDUCATION" V58 "COURT ORDER - DISCIPL PROCEDURES" V59 "COURT ORDER - RECREATION" V60 "COURT ORDER - VISITING, MAIL, PHONE" V61 "COURT ORDER - FIRE HAZARDS" V62 "COURT ORDER - COUNSELING PROGRAMS" V63 "COURT ORDER - INMATE CLASSIFICATION" V64 "COURT ORDER - LIBRARY SERVICES" V65 "COURT ORDER - GRIEVANCE PROCEDURES" V66 "COURT ORDER - RELIGIOUS" V67 "COURT ORDER - SEARCH POLICIES" V68 "COURT ORDER - OTHER" V69 "COURT ORDER - OTHER (SPECIFY)" V70 "COURT ORDER - TOTALITY OF CONDITIONS" V71 "ADP" V72 "ADP FLAG" V73 "INMATE COUNT ON 6-30-95" V74 "INMATE COUNT FLAG" V75 "MAXIMUM MALES" V76 "MAXIMUM MALES FLAG" V77 "MAXIMUM FEMALES" V78 "MAXIMUM FEMALES FLAG" V79 "MEDIUM MALES" V80 "MEDIUM MALES FLAG" V81 "MEDIUM FEMALES" V82 "MEDIUM FEMALES FLAG" V83 "MINIMUM MALES" V84 "MINIMUM MALES FLAG" V85 "MINIMUM FEMALES" V86 "MINIMUM FEMALES FLAG" V87 "NOT CLASSIFIED -MALES" V88 "NOT CLASSIFIED MALES FLAG" V89 "NOT CLASSIFIED - FEMALES" V90 "NOT CLASSIFIED - FEMALES FLAG" V91 "TOTAL - MALES" V92 "TOTAL - MALES FLAG" V93 "TOTAL - FEMALES" V94 "TOTAL - FEMALES FLAG" V95 "WHITE INMATES" V96 "WHITE INMATES FLAG" V97 "BLACK INMATES" V98 "BLACK INMATES FLAG" V99 "HISPANIC INMATES" V100 "HISPANIC INMATES FLAG" V101 "AMER. INDIAN/ALASKA NATIVE INM" V102 "AMER. INDIAN/ALASKA NATIVE FLAG" V103 "ASIAN/PACIFIC ISLANDER INMATES" V104 "ASIAN/PACIFIC ISLANDER FLAG" V105 "RACE UNKNOWN INMATES" V106 "RACE UNKNOWN INMATES FLAG" V107 "TOTAL INMATES" V108 "TOTAL INMATES FLAG" V109 "INMATES UNDER 18 YEARS OLD" V110 "INMATES UNDER 18 YEARS OLD FLAG" V111 "FULL-TIME PAYROLL STAFF" V112 "FULL-TIME PAYROLL STAFF FLAG" V113 "PART-TIME PAYROLL STAFF" V114 "PART-TIME NONPAYROLL FLAG" V115 "FULL-TIME NONPAYROLL STAFF" V116 "FULL-TIME NONPAYROLL FLAG" V117 "PART-TIME NONPAYROLL STAFF" V118 "PART-TIME NONPAYROLL FLAG" V119 "FULL-TIME CONTRACT STAFF" V120 "FULL-TIME CONTRACT FLAG" V121 "PART-TIME CONTRACT STAFF" V122 "PART-TIME CONTRACT FLAG" V123 "TOTAL FULL-TIME STAFF" V124 "TOTAL FULL-TIME STAFF FLAG" V125 "TOTAL PART-TIME STAFF" V126 "TOTAL PART-TIME STAFF FLAG" V127 "MALE ADMINISTRATORS" V128 "MALE ADMINISTRATORS FLAG" V129 "FEMALE ADMINISTRATORS" V130 "FEMALE ADMINISTRATORS FLAG" V131 "MALE CORRECTIONAL STAFF" V132 "MALE CORRECTIONAL STAFF FLAG" V133 "FEMALE CORRECTIONAL STAFF" V134 "FEMALE CORRECTIONAL STAFF FLAG" V135 "MALE CLERICAL STAFF" V136 "MALE CLERICAL STAFF FLAG" V137 "FEMALE CLERICAL STAFF" V138 "FEMALE CLERICAL STAFF FLAG" V139 "MALE EDUCATIONAL STAFF" V140 "MALE EDUCATIONAL STAFF FLAG" V141 "FEMALE EDUCATIONAL STAFF" V142 "FEMALE EDUCATIONAL STAFF FLAG" V143 "MALE PROF. TREAT & TECH. STAFF" V144 "MALE PROF. TREAT & TECH. FLAG" V145 "FEMALE PROF. TREAT & TECH. STAFF" V146 "FEMALE PROF. TREAT & TECH- FLAG" V147 "MALE MAINTENANCE STAFF" V148 "MALE MAINTENANCE STAFF FLAG" V149 "FEMALE MAINTENANCE STAFF" V150 "FEMALE MAINTENANCE STAFF FLAG" V151 "STAFF - OTHER (SPECIFY)" V152 "MALE - OTHER STAFF" V153 "MALE - OTHER STAFF FLAG" V154 "FEMALE - OTHER STAFF" V155 "FEMALE - OTHER STAFF FLAG" V156 "MALE - TOTAL STAFF" V157 "MALE - TOTAL STAFF FLAG" V158 "FEMALE - TOTAL STAFF" V159 "FEMALE - TOTAL STAFF FLAG" V160 "WHITE STAFF ON 6/30" V161 "WHITE STAFF ON 6/30 FLAG" V162 "BLACK STAFF ON 6/30" V163 "BLACK STAFF ON 6/30 FLAG" V164 "HISPANIC STAFF ON 6/30" V165 "HISPANIC STAFF ON 6/30 FLAG" V166 "A INDIAN/ALASKA NATIVE STAFF 6/30" V167 "A INDIAN/ALASKA NATIVE STAFF FLAG" V168 "ASIAN/PACIFIC ISLANDER STAFF 6/30" V169 "ASIAN/PACIFIC ISLANDER FLAG" V170 "RACE UNKNOWN STAFF" V171 "RACE UNKNOWN STAFF FLAG" V172 "TOTAL STAFF ON 6/30" V173 "TOTAL STAFF FLAG" V174 "DEATHS - ILLNESS/NATURAL CAUSES" V175 "DEATHS - ILLNESS/NATURAL FLAG" V176 "DEATHS - AIDS" V177 "DEATHS - AIDS FLAG" V178 "DEATHS -SUICIDE" V179 "DEATHS - SUICIDE FLAG" V180 "DEATHS - CAUSED BY OTHER INMATES" V181 "DEATHS - CAUSED BY OTHER FLAG" V182 "DEATHS - OTHER (SPECIFY)" V183 "DEATHS - OTHER" V184 "DEATHS - OTHER FLAG" V185 "DEATH TOTAL" V186 "DEATH - TOTAL FLAG" V187 "WORK ASSIGN - PRISON INDUSTRIES" V188 "WORK ASSIGN - FACILITY SUPPORT" V189 "WORK ASSIGN - FARMING" V190 "WORK ASSIGN - PUBLIC WORKS" V191 "WORK ASSIGN - OTHER" V192 "WORK ASSIGN - OTHER (SPECIFY)" V193 "WORK ASSIGN - NONE" V194 "INMATES ON WORK ASSIGNMENTS" V195 "INMATES ON WORK ASSIGNMENTS FLAG" V196 "EDUC. PROGRAMS - ABE" V197 "EDUC. PROGRAMS - GED" V198 "EDUC. PROGRAMS - SPEC EDUC" V199 "EDUC. PRORAMS-VOC TRAINING" V200 "EDUC. PROGRAM - COLLEGE COURSES" V201 "EDUC. PROGRAMS - STUDY RELEASE" V202 "EDUC. PROGRAMS - NONE" V203 "INMATES IN EDUC. PROGRAMS" V204 "INMATES IN EDUC. PROGRAMS FLAG" V205 "SPECIAL PROGRAMS - DRUG DEPEND" V206 "SPECIAL PROGRAMS - ALCOHOL DEPEND" V207 "SPECIAL PROGRAMS - PSYCHOLOGICAL" V208 "SPECIAL PROGRAMS - EMPLOYMENT" V209 "SPECIAL PROGRAMS - LIFE SKILLS" V210 "SPECIAL PROGRAMS -PARENTING" V211 "SPECIAL PROGRAMS - OTHER" V212 "SPECIAL PROGRAMS - OTHER (SPECIFY)" V213 "SPECIAL PROGRAMS - NONE" V214 "INMATES ON WORK RELEASE" V215 "NUMBER OF INMATES ON WORK RELEASE" V216 "NUMBER OF INMATES ON WORK FLAG" V217 "INMATES ON SHORT TERM RELEASE" V218 "NUMBER OF INM ON SHORT TERM RELEASE" V219 "NUMBER OF INM ON SHORT TERM FLAG" V220 "INMATES ON EMERGENCY LEAVE" V221 "NUMBER OF INMATES ON EMERGENCY LEAVE" V222 "NUMBER OF INMATES ON EMERG.LEAVE FLAG" V223 "BOOT CAMP ENVIRONMENT" V224 "NUMBER OF INMATES IN BOOT CAMP" V225 "NUMBER OF INMATES IN BOOT CAMP FLAG" V226 "ASSAULTS ON FACILITY STAFF" V227 "ASSAULTS ON FACILITY STAFF FLAG" V228 "ASSAULT ON OTHER INMATES" V229 "ASSAULTS ON OTHER INMATES FLAG" V230 "STAFF DEATHS FROM ASSAULTS" V231 "STAFF DEATHS FROM ASSAULTS FLAG" V232 "INMATE DEATHS FROM ASSAULTS" V233 "INMATE DEATHS FROM ASSAULTS FLAG" V234 "RIOTS" V235 "RIOTS FLAG" V236 "FIRES" V237 "FIRES FLAG" V238 "OTHER DISTURBANCES - OTHER (SPECIFY)" V239 "OTHER DISTURBANCES" V240 "OTHER DISTURBANCES FLAG" V241 "DISCIPLINARY ACTION UNIT" V242 "NUMBER OF INMATES IN DISCIPL CUST" V243 "NUMBER OF INMATES IN DISCIPL FLAG" V244 "PROTECTIVE CUSTODY UNIT" V245 "NUMBER OF INMATES IN PROTECT CUST" V246 "NUMBER OF INMATES IN PROTECT FLAG" V247 "ADMINISTRATIVE SEGREGATION UNIT" V248 "NUMBER OF INMATES IN ADMIN CUST" V249 "NUMBER OF INMATE IN ADMIN FLAG" V250 "FACILITY HOUSES NON-CITIZENS" V251 "NUMBER OF NON-CITIZEN INMATES" V252 "NUMBER OF NON-CITIZEN FLAG" V253 "FACILITY HOUSES DEATH SENT INMATES" V254 "NUMBER OF DEATH ROW INMATES" V255 "NUMBER OF DEATH ROW INMATE FLAG" V256 "DO CHILDREN STAY OVERNIGHT" V257 "ON 6/30, DID CHILDREN STAY OVERNIGHT" V258 "NUMBER OF CHILDREN OVERNIGHT 6/30" V259 "NUMBER OF CHILDREN OVER 6/30 FLAG" V260 "OTHER PROG PROMOTE INM./CHILD VISITS" V261 "FORMAL PROGRAMS - OTHER SPECIFY" V262 "COMMENT FLAG" V263 "LINKER FIELD" V264 "ICPSR STUDY NUMBER" V265 "EDITION NUMBER" V266 "PART NUMBER". * SPSS VALUE LABELS COMMAND. VALUE LABELS V1 1 "Alabama" 2 "Alaska" 3 "Arizona" 4 "Arkansas" 5 "California" 6 "Colorado" 7 "Connecticut" 8 "Delaware" 9 "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" / V2 0 "State" 2 "Municipal" 6 "Federal" / V5 7 "State Adult Corrections" 8 "Federal Adult Corrections" / V12 999999999 "Inap" / V13 1 "Federal" 2 "State" 3 "Private" 4 "Joint local" / V14 1 "50% or more" 2 "Less than 50%" / V15 1 "Males only" 2 "Females only" 3 "Both males and females" / V16 1 "Maximum/close/high" 2 "Medium" 3 "Minimum/low" 4 "None" 5 "Administrative unit" / V17 0 "No" 1 "Yes" 9 "Inap" / V19 0 "Actual data" 1 "Estimated data" 8 "Not applicable" / V20 0 "No" 1 "Yes" / V22 0 "Actual data" 1 "Estimated data" / V23 0 "Unknown/NA" 1 "Yes" / V24 0 "Unknown/NA" 1 "Yes" / V25 0 "Unknown/NA" 1 "Yes" / V26 0 "Unknown/NA" 1 "Yes" / V27 0 "Unknown/NA" 1 "Yes" / V28 0 "Unknown/NA" 1 "Yes" / V29 0 "Unknown/NA" 1 "Yes" / V30 0 "Unknown/NA" 1 "Yes" / V31 0 "Unknown/NA" 1 "Yes" / V33 1 "General pop. confinement" 2 "Boot camp" 3 "Reception/diag/class" 4 "Medical treatment/hospital" 5 "Alcohol/drug treatment" 6 "Primarily for youthful offenders" 7 "Work release/prerelease" 8 "For persons returned to custody" 9 "Other function" / V35 0 "Actual data" 1 "Estimated data" / V37 0 "Actual data" 1 "Estimated data" 8 "Not applicable" 9 "Not available, unknown, dont know" / V39 0 "Unknown/NA" 1 "Yes" / V40 0 "Unknown/NA" 1 "Yes" / V41 0 "Unknown/NA" 1 "Yes" / V42 0 "Unknown/NA" 1 "Yes" / V43 1 "No change in bed capacity" 2 "An increase in capacity of beds" 3 "A decrease in capacity of beds" / V44 0 "Missing" 9 "Inap" / V45 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V47 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V48 1 "yes" 2 "no" / V50 0 "Actual data" 1 "Estimated data" / V51 1 "No" 2 "Yes" / V52 0 "NA" 1 "Yes" / V53 0 "NA" 1 "Yes" / V54 0 "NA" 1 "Yes" / V55 0 "NA" 1 "Yes" / V56 0 "NA" 1 "Yes" / V57 0 "NA" 1 "Yes" / V58 0 "NA" 1 "Yes" / V59 0 "NA" 1 "Yes" / V60 0 "NA" 1 "Yes" / V61 0 "NA" 1 "Yes" / V62 0 "NA" 1 "Yes" / V63 0 "NA" 1 "Yes" / V64 0 "NA" 1 "Yes" / V65 0 "NA" 1 "Yes" / V66 0 "NA" 1 "Yes" / V67 0 "NA" 1 "Yes" / V68 0 "NA" 1 "Yes" / V70 1 "Yes" 2 "No" / V72 0 "Actual data" 1 "Estimated data" / V74 0 "Actual data" 1 "Estimated data" / V76 0 "Actual data" 1 "Estimated data" / V78 0 "Actual data" 1 "Estimated data" / V80 0 "Actual data" 1 "Estimated data" / V82 0 "Actual data" 1 "Estimated data" / V84 0 "Actual data" 1 "Estimated data" 8 "Not applicable" / V86 0 "Actual data" 1 "Estimated data" / V88 0 "Actual data" 1 "Estimated data" 8 "Not applicable" 9 "Not available, unknown, or dont know" / V90 0 "Actual data" 1 "Estimated data" 8 "Not applicable" / V92 0 "Actual data" 1 "Estimated data" / V94 0 "Actual data" 1 "Estimated data" / V96 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V98 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V100 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V102 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V104 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V106 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V108 0 "Actual data" 1 "Estimated data" 8 "Not applicable" 9 "Not available, unknown, or dont know" / V110 0 "Actual data" 1 "Estimated data" 8 "Not applicable" 9 "Not available, unknown, or dont know" / V112 0 "Actual data" 1 "Estimated data" 6 "Shared staff" / V114 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V116 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V118 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V120 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V122 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V124 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V125 999999 "Inap" / V126 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V128 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V130 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V132 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V134 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 8 "Not applicable" 9 "Not available, unknown, or dont know" / V136 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V138 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V140 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V142 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V144 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V146 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V148 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V150 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V153 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V155 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V157 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V158 999999 "Inap" / V159 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V161 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V163 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V165 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V167 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V169 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V171 0 "Actual data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V173 0 "Actual data" 1 "Estimated data" 6 "Shared staff" 9 "Not available, unknown, or dont know" / V175 0 "Actual data" 1 "Estimated data" / V177 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V179 0 "Actual data" 1 "Estimated data" / V181 0 "Actual data" 1 "Estimated data" / V183 999999 "Inap" / V184 0 "Actual data" 1 "Estimated data" 8 "Not applicable" / V186 0 "Actual data" 1 "Estimated data" / V187 0 "NA" 1 "Yes" / V188 0 "NA" 1 "Yes" / V189 0 "NA" 1 "Yes" / V190 0 "NA" 1 "Yes" / V191 0 "NA" 1 "Yes" / V193 0 "NA" 1 "Yes" / V195 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V197 0 "NA" 1 "Yes" / V198 0 "NA" 1 "Yes" / V199 0 "NA" 1 "Yes" / V200 0 "NA" 1 "Yes" / V201 0 "NA" 1 "Yes" / V202 0 "NA" 1 "Yes" / V204 0 "Actual data" 1 "Estimated data" 8 "Not applicable" 9 "Not available, unknown, or dont know" / V205 0 "NA" 1 "Yes" / V206 0 "NA" 1 "Yes" / V207 0 "NA" 1 "Yes" / V208 0 "NA" 1 "Yes" / V209 0 "NA" 1 "Yes" / V210 0 "NA" 1 "Yes" / V211 0 "NA" 1 "Yes" / V213 0 "NA" 1 "Yes" / V214 1 "yes" 2 "no" / V216 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V217 1 "yes" 2 "no" / V219 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V220 1 "yes" 2 "no" / V222 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V223 1 "yes" 2 "no" / V225 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V227 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V229 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V231 0 "Actual data" 1 "Estimated data" / V233 0 "Actual data" 1 "Estimated data" / V234 999999 "Inap" / V235 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V237 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V240 0 "Actual data" 1 "Estimated data" 8 "Not applicable" 9 "Not available, unknown, or dont know" / V241 1 "yes" 2 "no" / V243 0 "Actual data" 1 "Estimated data" 2 "Undifferentiated housing" 9 "Not available, unknown, or dont know" / V244 1 "yes" 2 "no" / V246 0 "Actual data" 1 "Estimated data" 2 "Undifferentiated housing" 9 "Not available, unknown, or dont know" / V247 1 "yes" 2 "no" / V249 0 "Actual data" 1 "Estimated data" 2 "Undifferentiated housing" 9 "Not available, unknown, or dont know" / V250 1 "yes" 2 "no" 3 "dont know" / V252 0 "Actual data" 1 "Estimated data" 9 "Not available, unknown, or dont know" / V253 1 "yes" 2 "no" / V255 0 "Actual data" 1 "Estimated data" / V256 1 "yes" 2 "no" / V257 1 "yes" 2 "no" / V259 0 "Actual data" 1 "Estimated data" 8 "Not applicable" 9 "Not available" / V260 1 "yes" 2 "no" / V262 1 "Independent Federal prison camps" 2 "A satellite facility" 3 "Facility has day reporters" 4 "Facility has inmates on tether prog" 9 "Inap" /. * SPSS MISSING VALUES COMMAND. MISSING VALUES V12 (999999999) V17 (9) V36 (999999) V38 (999) V44 (0, 9) V46 (999999) V85 (999) V87 (999999) V89 (999999) V95 (999999) V97 (999999) V99 (999999) V101 (999999) V103 (999999) V105 (999999) V109 (999999) V111 ('999999') V113 (999999) V115 (999999) V117 (999999) V119 (999999) V121 (999999) V123 (999999) V125 (999999) V127 (999999) V129 (999999) V131 (999999) V133 (999999) V137 (999999) V139 (999999) V141 (999999) V143 (999999) V145 (999999) V147 (999999) V149 (999999) V152 (999999) V154 (999999) V156 (999999) V158 (999999) V160 (999999) V162 (999999) V164 (999999) V166 (999999) V168 (999999) V170 (999999) V172 (999999) V176 (999999) V183 (999999) V194 (999999) V203 (999999) V215 (999999) V218 (999999) V221 (999999) V226 (999999) V228 (999999) V234 (999999) V236 (999999) V239 (999999) V242 (999999) V245 (999999) V248 (999999) V251 (999999) V258 (999999) V262 (9) V263 (99) . *** NOTE: There's a mistake in the above coding for v51; it should be as follows: VALUE LABLES v51 1 "Yes" 2 "No" . ***Generate id for 6953. ************************************************************************ ** CREATING THE ID ************************************************************************ ** 1995 PRISON ************************************************************************ NUMERIC id (f16.0). COMPUTE id = v6 * 1 + v5 * 10**5 + v4 * 10**7 + v3 * 10**10 + v2 * 10**13 + v1 * 10**14. 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 v1 (else = copy) into state. RECODE v73 (else = copy) into count. RECODE v71 (else = copy) into ADP. RECODE v48 (1 = 1) (2 = 0) into popcp. RECODE v51 (1 = 1) (2 = 0) into ord_o. COMPUTE order = 0. IF(v51 = 1 |v52 = 1 |v53 = 1 |v54 = 1 |v55 = 1 |v56 = 1 |v57 = 1 |v58 = 1 | v59 = 1 |v60 = 1 | v61 = 1 |v62 = 1 |v63 = 1 |v64 = 1 |v65 = 1 |v66 = 1 |v67 = 1 |v68 = 1 | v70 = 1 ) order = 1. COMPUTE ordsm = 0. IF popcp = 1 | order = 1 ordsm = 1. COMPUTE S = 1. FORMATS popcp ord_o order ordsm S (F1.0). FORMATS ADP count (F8.0). FORMATS state (F2.0). VARIABLE LABELS order "non-population cap order" ordsm "Population cap or other order" ord_o "BJS summary: non-pop cap order" S "In the 1995 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" / popcp order ordsm ord_o S 0 "No (0)" 1 "Yes (1)" . MATCH FILES FILE = * /KEEP id S state count ADP popcp order ordsm ord_o ALL. SAVE OUTFILE = 'D:/TechnicalAppendix/CorrectionalCensuses/Prison1995.sav' . *** APPEND "_95" to each variable name *** Remember: each variable name must be 5 or fewer characters FLIP. STRING newname(A8). COMPUTE newname=CONCAT(RTRIM(case_lbl),'_95'). WRITE OUTFILE='D:\temp\rename.sps' / 'RENAME VARIABLE ('case_lbl'='newname').'. EXECUTE. GET FILE = 'D:\TechnicalAppendix\CorrectionalCensuses\Prison1995.sav' . INCLUDE 'D:\temp\rename.sps'. RENAME VARIABLE (id_95 = id). SAVE OUTFILE = 'D:\TechnicalAppendix\CorrectionalCensuses\Prison1995.sav' .