*** Merged Jail Data: panelizing *** NEED TO DO THIS TWICE, *** TO COVER BOTH FACIL level and juris level. DEFINE !Path1 ()'H:\\DATA\BJS\AllCensuses\'!enddefine. *FACILITY LEVEL FIRST. GET FILE=!Path1+"Jail1983-1993_facil.sav" . *** FIRST NEED TO INCLUDE ONLY A FEW VARIABLES *** AND REGULARIZE THEIR NAMES *** STRIP DOWN FILE *** INCLUDE ONLY THE COURT ORDER VARIABLES, *** AND ADP, ADMISSIONS, COUNT, AND IDENTIFIERS MATCH FILES FILE = * /KEEP id99 to ord_o_83 state_93 to v6_93 v12_93 v47n_93 to v68n_93 v48B_93 v67_93 v69_93 v248B_93 state_88 to v13_88 v39_88 v41_88 to v56_88 v186_88 state_83 to v9_83 v42_83 v119_83 . SAVE OUTFILE='C:\temp\Jail_all_limit.sav' . RENAME VARIABLES (jurid99 = jurid) (v1b_93=gov_93) (v7_88=gov_88) (v6_83=gov_83) (v248B_93=adm_93) (v186_88=adm_88) (v119_83=adm_83) (v48b_93=max_93) (v39_88=max_88) (v42_83=max_83) (v67_93=ost_93) (v69_93=ost2_93) (v50n_93=crowd_93) (v51n_93=rec_93) (v52n_93=med_93) (v53n_93=staff_93) (v54n_93=disc_93) (v55n_93=food_93) (v56n_93=class_93) (v57n_93=libr_93) (v58n_93=visit_93) (v59n_93=adseg_93) (v60n_93=prot_93) (v61n_93=griev_93) (v62n_93=educ_93) (v63n_93=fire_93) (v64n_93=coun_93) (v65n_93=total_93) (v66n_93=oth_93) (v68n_93=oth2_93) (v41_88=crowd_88) (v42_88=rec_88) (v43_88=med_88) (v44_88=staff_88) (v45_88=disc_88) (v46_88=food_88) (v47_88=class_88) (v48_88=libr_88) (v49_88=visit_88) (v50_88=adseg_88) (v51_88=griev_88) (v52_88=educ_88) (v53_88=fire_88) (v54_88=coun_88) (v55_88=total_88) (v56_88=oth_88) (v12_93=comp_93) . *** MAKE CODES/VALUES/LABELS UNIFORM. ***Diagnostics: run frequencies *FREQUENCIES VARIABLES=S_93 use_93 S_88 S_83 count_93 ADP_93 popcp_93 order_93 ordsm_93 ord_o_93 count_88 ADP_88 popcp_88 order_88 ordsm_88 ord_o_88 count_83 ADP_83 popcp_83 ordsm_83 ord_o_83 state_93 comp_93 v47n_93 v49n_93 crowd_93 rec_93 med_93 staff_93 disc_93 food_93 class_93 libr_93 visit_93 adseg_93 prot_93 griev_93 educ_93 fire_93 coun_93 total_93 oth_93 oth2_93 max_93 ost_93 ost2_93 adm_93 state_88 max_88 crowd_88 rec_88 med_88 staff_88 disc_88 food_88 class_88 libr_88 visit_88 adseg_88 griev_88 educ_88 fire_88 coun_88 total_88 oth_88 adm_88 state_83 max_83 adm_83 /ORDER= ANALYSIS . * Make NAs for court orders into Nos (and in the max, make NA into SYSMIS) * Recode missing (unreported info for present facilities) as -9, consistently. *** Also RECODE 1993 values to make consistent with others. *** 3 is maybe (jurisdiction = yes, so each facility = maybe). Make it yes. *** 9 is missing. Make it -9. RECODE popcp_93 order_93 ordsm_93 ord_o_93 (3 = 1) (9 = -9). RECODE crowd_93 to oth2_93 (3 = 1) (8=0) (9 = -9). RECODE oth2_93 (98 = 0) (99=-9). RECODE max_93 (99998, 99999 = SYSMIS). MISSING VALUE adm_93 (). RECODE adm_93 (998, 999 = -9). MISSING VALUE max_88 (). RECODE max_88 (0 = SYSMIS). MISSING VALUE max_83(). RECODE max_83 (-1 = SYSMIS). VARIABLE LABEL comp_93 "Complete data provided?". RECODE comp_93 (2=0). VALUE LABEL comp_93 1 "Yes (1)" 0 "No (0)". *** Recode admission figures to make them covering the same period. COMPUTE adm_93 = 365*adm_93. IF adm_93 = -3285 adm_93 = -9. APPLY DICTIONARY from * /SOURCE VARIABLES = gov_93 /TARGET VARIABLES = gov_88 gov_83. EXECUTE. VALUE LABELS popcp_93 order_93 ordsm_93 ord_o_93 crowd_93 to total_93 oth2_93 popcp_88 order_88 ordsm_88 ord_o_88 popcp_83 ordsm_83 ord_o_83 -9 "Unreported; all facilities (-9)" 0 "No; all facilities (0)" 1 "Yes; at least one facility (1)" . FORMATS crowd_93 to total_93 oth2_93 (F2.0). IF ost_93 = ('999999999999999999999999999998') ost_93 = ''. IF ost_93 = ('999999999999999999999999999999') ost_93 = ''. IF ost2_93 = ('999999999999999999999999999998') ost2_93 = ''. IF ost2_93 = ('999999999999999999999999999999') ost2_93 = ''. *** Diagnostic again. *FREQUENCIES VARIABLES=popcp_93 to ord_o_83 /ORDER= ANALYSIS . *FREQUENCIES VARIABLES=gov_93 gov_88 gov_83 /ORDER= ANALYSIS . *FREQUENCIES VARIABLES= crowd_93 rec_93 med_93 staff_93 disc_93 food_93 class_93 libr_93 visit_93 adseg_93 prot_93 griev_93 educ_93 fire_93 coun_93 total_93 oth_93 oth2_93 max_93 ost_93 ost2_93 crowd_88 rec_88 med_88 staff_88 disc_88 food_88 class_88 libr_88 visit_88 adseg_88 griev_88 educ_88 fire_88 coun_88 total_88 oth_88 max_88 max_83 /ORDER= ANALYSIS . **** EVERYTHING LOOKS OK. COMPUTE state_93 = state. COMPUTE state_88 = state. COMPUTE state_83 = state. STRING fac_93 fac_88 fac_83 (A45). COMPUTE fac_93 = facility. COMPUTE fac_88 = facility. COMPUTE fac_83 = facility. MATCH FILES FILE = * /KEEP state_93 state_88 state_83 fac_93 fac_88 fac_83 ALL. FORMATS state_93 to state_83 (F2.0). VALUE LABLES state_93 to state_83 1 'Alabama (1)' 2 'Alaska (2)' 3 'Arizona (3)' 4 'Arkansas (4)' 5 'California (5)' 6 'Colorado (6)' 7 'Connecticut (7)' 8 'Delaware (8)' 9 'District of Columbia (9)' 10 'Florida (10)' 11 'Georgia (11)' 12 'Hawaii (12)' 13 'Idaho (13)' 14 'Illinois (14)' 15 'Indiana (15)' 16 'Iowa (16)' 17 'Kansas (17)' 18 'Kentucky (18)' 19 'Louisiana (19)' 20 'Maine (20)' 21 'Maryland (21)' 22 'Massachusetts (22)' 23 'Michigan (23)' 24 'Minnesota (24)' 25 'Mississippi (25)' 26 'Missouri (26)' 27 'Montana (27)' 28 'Nebraska (28)' 29 'Nevada (29)' 30 'New Hampshire (30)' 31 'New Jersey (31)' 32 'New Mexico (32)' 33 'New York (33)' 34 'North Carolina (34)' 35 'North Dakota (35)' 36 'Ohio (36)' 37 'Oklahoma (37)' 38 'Oregon (38)' 39 'Pennsylvania (39)' 40 'Rhode Island (40)' 41 'South Carolina (41)' 42 'South Dakota (42)' 43 'Tennessee (43)' 44 'Texas (44)' 45 'Utah (45)' 46 'Vermont (46)' 47 'Virginia (47)' 48 'Washington (48)' 49 'West Virginia (49)' 50 'Wisconsin (50)' 51 'Wyoming (51)' . *** CUT UNNEEDED VARIABLES MATCH FILES FILE = * /DROP use_93 merge v1A_93 V1C_93 V1D_93 V1E_93 V1F_93 V1G_93 V2_93 V3_93 V4_93 V5_93 V6_93 v47n_93 v49n_93 V1_88 V2_88 V3_88 V4_88 V5_88 V6_88 V8_88 V9_88 V10_88 V11_88 V12_88 V13_88 V1_83 V2_83 V3_83 V4_83 V5_83 V7_83 V8_83 V9_83 . RENAME VARIABLES (add1_93 = name_93). SAVE OUTFILE=!Path1+'Jail_facil_for_transfer.sav' /COMPRESSED. ******************************************************** *Jurisdictional level *DEFINE !Path1 ()'C:\\Margo\DATA\BJS\AllCensuses\'!enddefine. DEFINE !Path1 ()'H:\\DATA\BJS\AllCensuses\'!enddefine. GET FILE=!Path1+"Jail1983-1999_juris.sav" . *** FIRST NEED TO INCLUDE ONLY A FEW VARIABLES *** AND REGULARIZE THEIR NAMES *** STRIP DOWN FILE *** INCLUDE ONLY THE COURT ORDER VARIABLES, *** AND ADP, ADMISSIONS, COUNT, AND IDENTIFIERS MATCH FILES FILE = * /DROP v1a_99 v3_99 to v9_99 v15_99 v16_99 to v52_99 v178_99 v182_99 v186_99 use_93 v14_93 v15_93 v17_93 v18_93 v113b_93 v288b_93 v48b_93n v47_93 v48b_93 v48b_93m v49_93 v78_88 v216_88 v38_88 v40_88 v63_83 v112_83 v41_83 v450_83 . RENAME VARIABLES (jurid99 = jurid) (v1b_99 = gov_99) (v14c_99 = comp_99) (v14x_99 = n_99) (v171_99 = adm_99) (v180_99 = capac_99) (v183_99 = max_99) (v185x_99 = popyr_99) (v204_99 = ost_99) (v187_99 = crowd_99) (v188_99 = med_99) (v189_99 = adseg_99) (v190_99 = staff_99) (v191_99 = food_99) (v192_99 = educ_99) (v193_99 = disc_99) (v194_99 = rec_99) (v195_99 = visit_99) (v196_99 = fire_99) (v197_99 = coun_99) (v198_99 = class_99) (v199_99 = libr_99) (v200_99 = griev_99) (v201_99 = relig_99) (v202_99 = serch_99) (v203_99 = oth_99) (v1b_93=gov_93) (v2_93 = name_93) (v7_88=gov_88) (v6_83=gov_83) (v248_93a=adm_93) (v186_88=adm_88) (v119_83=adm_83) (v48b_93a=max_93) (v39_88=max_88) (v42_83a=max_83) (v67_93=ost_93) (v69_93=ost2_93) (v50_93=crowd_93) (v51_93=rec_93) (v52_93=med_93) (v53_93=staff_93) (v54_93=disc_93) (v55_93=food_93) (v56_93=class_93) (v57_93=libr_93) (v58_93=visit_93) (v59_93=adseg_93) (v60_93=prot_93) (v61_93=griev_93) (v62_93=educ_93) (v63_93=fire_93) (v64_93=coun_93) (v65_93=total_93) (v66_93=oth_93) (v68_93=oth2_93) (v7_88 = gov_88) (v41_88=crowd_88) (v42_88=rec_88) (v43_88=med_88) (v44_88=staff_88) (v45_88=disc_88) (v46_88=food_88) (v47_88=class_88) (v48_88=libr_88) (v49_88=visit_88) (v50_88=adseg_88) (v51_88=griev_88) (v52_88=educ_88) (v53_88=fire_88) (v54_88=coun_88) (v55_88=total_88) (v56_88=oth_88) (v12_93=comp_93) (v44b_93= capac_93) (v12_93 = comp_93) (v35_88 = capac_88) (v40_83 = capac_83) . *** MAKE CODES/VALUES/LABELS UNIFORM. ***Diagnostics: run frequencies *FREQUENCIES VARIABLES= s_99 to max_83 /ORDER= ANALYSIS . VARIABLE LABEL comp_93 "Complete data provided?". RECODE comp_93 (2=0). VALUE LABEL comp_93 1 "Yes (1)" 0 "No (0)". *** Recode admission figures to make them covering the same period. COMPUTE adm_93 = 365*adm_93. COMPUTE adm_99 = 52*adm_99 . APPLY DICTIONARY from * /SOURCE VARIABLES = gov_99 /TARGET VARIABLES = gov_93 gov_88 gov_83. EXECUTE. IF ost_93 = ('999999999999999999999999999998') ost_93 = ''. IF ost_93 = ('999999999999999999999999999999') ost_93 = ''. IF ost2_93 = ('999999999999999999999999999998') ost2_93 = ''. IF ost2_93 = ('999999999999999999999999999999') ost2_93 = ''. **** EVERYTHING ELSE LOOKS OK. COMPUTE state_99 = state. COMPUTE state_93 = state. COMPUTE state_88 = state. COMPUTE state_83 = state. FORMATS state_99 state_93 state_88 state_83 (F2.0). STRING fac_99 fac_93 fac_88 fac_83 (A45). COMPUTE fac_99 = facility. COMPUTE fac_93 = facility. COMPUTE fac_88 = facility. COMPUTE fac_83 = facility. VALUE LABLES state_99 to state_83 1 'Alabama (1)' 2 'Alaska (2)' 3 'Arizona (3)' 4 'Arkansas (4)' 5 'California (5)' 6 'Colorado (6)' 7 'Connecticut (7)' 8 'Delaware (8)' 9 'District of Columbia (9)' 10 'Florida (10)' 11 'Georgia (11)' 12 'Hawaii (12)' 13 'Idaho (13)' 14 'Illinois (14)' 15 'Indiana (15)' 16 'Iowa (16)' 17 'Kansas (17)' 18 'Kentucky (18)' 19 'Louisiana (19)' 20 'Maine (20)' 21 'Maryland (21)' 22 'Massachusetts (22)' 23 'Michigan (23)' 24 'Minnesota (24)' 25 'Mississippi (25)' 26 'Missouri (26)' 27 'Montana (27)' 28 'Nebraska (28)' 29 'Nevada (29)' 30 'New Hampshire (30)' 31 'New Jersey (31)' 32 'New Mexico (32)' 33 'New York (33)' 34 'North Carolina (34)' 35 'North Dakota (35)' 36 'Ohio (36)' 37 'Oklahoma (37)' 38 'Oregon (38)' 39 'Pennsylvania (39)' 40 'Rhode Island (40)' 41 'South Carolina (41)' 42 'South Dakota (42)' 43 'Tennessee (43)' 44 'Texas (44)' 45 'Utah (45)' 46 'Vermont (46)' 47 'Virginia (47)' 48 'Washington (48)' 49 'West Virginia (49)' 50 'Wisconsin (50)' 51 'Wyoming (51)' . SAVE OUTFILE=!Path1+'Jail_juris_for_transfer.sav' /COMPRESSED. *** ONCE THIS IS DONE, THE NEXT THING IS TO TRANSFER THE DATA OVER TO STATA, VIA STAT-TRANSFER. *** REMEMBER TO MAKE THE ID A "double" variable type, not "floating" or "long". *** THEN RUN "jail_facil_panel.do" and "jail_juris_panel.do" *** Then transfer it back, again via stat transfer, *** Finally, run "panelizing jails part 2". *** NOTE: VARIABLES CURRENTLY OMITTED THAT probably SHOULD BE THERE: *** N_93, 88 and 83 -- the number of facilities in these years in the jurisdictional file. *** THIS IS EASY: JUST MOVE DATA FROM S TO N, EXCEPT IN 1999.