*** Merged Prison Data: panelizing DEFINE !Path1 ()'H:\\DATA\BJS\AllCensuses\'!enddefine. *** FIRST NEED TO INCLUDE ONLY A FEW VARIABLES *** AND REGULARIZE THEIR NAMES GET FILE=!Path1+"Prison1984-2000.sav". *** STRIP DOWN FILE *** INCLUDE ONLY THE COURT ORDER VARIABLES, *** AND ADP, COUNT, AND IDENTIFIERS MATCH FILES FILE = * /KEEP id to v11_95 v13_95 v48_95 to v74_95 state_90 to v12_90 v43_90 to v62_90 state_84 to v8_84 v43_84 to v45_84 v55_84 v56_84 v67_84 v68_84 v714_84 to v730_84 flag_fed to region . MATCH FILES FILE = * /DROP v6_0 v12b_0 v13_0 ststr_0 v12a_0 ctord_0 v1_95 v3_95 v4_95 v5_95 v6_95 v10_95 v50_95 v51_95 v71_95 v72_95 v73_95 v74_95 v1_90 v2_90 v3_90 v4_90 v5_90 v7_90 v8_90 v9_90 v11_90 v45_90 v62_90 v1_84 v2_84 v3_84 v4_84 v5_84 v6_84 v7_84 v8_84 v45_84 v55_84 v56_84 v67_84 v68_84 v714_84 . RENAME VARIABLES (v11a_0=max_0). RENAME VARIABLES (v11b_0=popyr_0). RENAME VARIABLES (v12a01_0=crowd_0). RENAME VARIABLES (v12a02_0=adseg_0). RENAME VARIABLES (v12a03_0=disc_0). RENAME VARIABLES (v12a04_0=griev_0). RENAME VARIABLES (v12a05_0=serch_0). RENAME VARIABLES (v12a06_0=staff_0). RENAME VARIABLES (v12a07_0=food_0). RENAME VARIABLES (v12a08_0=med_0). RENAME VARIABLES (v12a09_0=mh_0). RENAME VARIABLES (v12a10_0=visit_0). RENAME VARIABLES (v12a11_0=rec_0). RENAME VARIABLES (v12a12_0=fire_0). RENAME VARIABLES (v12a13_0=coun_0). RENAME VARIABLES (v12a14_0=class_0). RENAME VARIABLES (v12a15_0=libr_0). RENAME VARIABLES (v12a16_0=relig_0). RENAME VARIABLES (v12a17_0=educ_0). RENAME VARIABLES (v12a18_0=disab_0). RENAME VARIABLES (v12a19_0=other_0). RENAME VARIABLES (v12c_0=totyr_0). RENAME VARIABLES (v2_95=govt_95). RENAME VARIABLES (v7_95=fac_95). RENAME VARIABLES (v8_95=addr_95). RENAME VARIABLES (v9_95=city_95). RENAME VARIABLES (v11_95=zip_95). RENAME VARIABLES (v13_95=priv_95). RENAME VARIABLES (v48_95=pop_95). RENAME VARIABLES (v49_95=max_95). RENAME VARIABLES (v52_95=crowd_95). RENAME VARIABLES (v53_95=med_95). RENAME VARIABLES (v54_95=adseg_95). RENAME VARIABLES (v55_95=staff_95). RENAME VARIABLES (v56_95=food_95). RENAME VARIABLES (v57_95=educ_95). RENAME VARIABLES (v58_95=disc_95). RENAME VARIABLES (v59_95=rec_95). RENAME VARIABLES (v60_95=visit_95). RENAME VARIABLES (v61_95=fire_95). RENAME VARIABLES (v62_95=coun_95). RENAME VARIABLES (v63_95=class_95). RENAME VARIABLES (v64_95=libr_95). RENAME VARIABLES (v65_95=griev_95). RENAME VARIABLES (v66_95=relig_95). RENAME VARIABLES (v67_95=serch_95). RENAME VARIABLES (v68_95=oth_95). RENAME VARIABLES (v69_95=oth2_95). RENAME VARIABLES (v70_95=total_95). RENAME VARIABLES (v6_90=govt_90). RENAME VARIABLES (v10_90=fac_90). RENAME VARIABLES (v12_90=priv_90). RENAME VARIABLES (v43_90=pop_90). RENAME VARIABLES (v44_90=max_90). RENAME VARIABLES (v46_90=crowd_90). RENAME VARIABLES (v47_90=med_90). RENAME VARIABLES (v48_90=adseg_90). RENAME VARIABLES (v49_90=staff_90). RENAME VARIABLES (v50_90=food_90). RENAME VARIABLES (v51_90=educ_90). RENAME VARIABLES (v52_90=disc_90). RENAME VARIABLES (v53_90=rec_90). RENAME VARIABLES (v54_90=visit_90). RENAME VARIABLES (v55_90=fire_90). RENAME VARIABLES (v56_90=coun_90). RENAME VARIABLES (v57_90=class_90). RENAME VARIABLES (v58_90=libr_90). RENAME VARIABLES (v59_90=griev_90). RENAME VARIABLES (v60_90=oth_90). RENAME VARIABLES (v61_90 = total_90) . RENAME VARIABLES (v43_84=pop_84). RENAME VARIABLES (v44_84=max_84). RENAME VARIABLES (v715_84=crowd_84). RENAME VARIABLES (v716_84=med_84). RENAME VARIABLES (v717_84=rec_84). RENAME VARIABLES (v718_84=visit_84). RENAME VARIABLES (v719_84=fire_84). RENAME VARIABLES (v720_84=staff_84). RENAME VARIABLES (v721_84=educ_84). RENAME VARIABLES (v722_84=coun_84). RENAME VARIABLES (v723_84=food_84). RENAME VARIABLES (v724_84=discr_84). RENAME VARIABLES (v725_84=griev_84). RENAME VARIABLES (v726_84=adseg_84). RENAME VARIABLES (v727_84=oth_84). RENAME VARIABLES (v728_84=oth3_84). RENAME VARIABLES (v729_84=oth4_84). RENAME VARIABLES (v730_84=oth5_84). RENAME VARIABLES (fed_n0=fed_95). COMPUTE fed_90 = fed_95. COMPUTE fed_84 = fed_95. EXECUTE. RECODE crowd_84 to adseg_84 (0 = 0) (1, 2, 3 = 1). NUMERIC libr_84(f1.0). VARIABLE LABEL libr_84 "Library Court Order". VALUE LABEL libr_84 1 "Yes (1)" 0 "No (0)". RECODE oth_84 (1 = 1) (0 = 0) (9=0) into libr_84. RECODE oth4_84 (1 = 1) into libr_84. RECODE oth_84 (9 = 1). RECODE oth4_84 (9 = 1) into oth_84. RECODE priv_90 priv_95 (3=1) (1,2,4 = 0). EXECUTE. VALUE LABELS crowd_84 to oth_84 0 "No" 1 "Yes" . FORMATS max_0 max_84 max_90 (F6) totyr_0 popyr_0 (F4) ADP_0 count_0 (F8) zip_0 zip_95 (F9) fed_84 fed_90 idflag s_0 total_0 (F1) . MATCH FILES FILE = * /DROP oth3_84 oth4_84 oth2_95 oth5_84 gov govt_90 govt_95 pop_84 pop_90 pop_95 . EXECUTE. SAVE OUTFILE=!Path1+"Prison_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 prisonpanel.do *** Then transfer it back, again via stat transfer, *** Finally, run panelizing prisons part 2.