*** MERGE PRISON FILES

GET FILE = 'D:\TechnicalAppendix\CorrectionalCensuses\Prison1984.sav' .

SORT CASES BY id (A).

SAVE OUTFILE = 'D:\TechnicalAppendix\CorrectionalCensuses\Prison1984.sav' .


GET FILE = 'D:\TechnicalAppendix\CorrectionalCensuses\Prison1990.sav' .

SORT CASES BY id (A).

SAVE OUTFILE = 'D:\TechnicalAppendix\CorrectionalCensuses\Prison1990.sav' .

GET FILE = 'D:\TechnicalAppendix\CorrectionalCensuses\Prison1995.sav' .

SORT CASES BY id (A).

MATCH FILES /FILE=*
 /FILE='D:\TechnicalAppendix\CorrectionalCensuses\Prison1990.sav'
 /BY id.

MATCH FILES /FILE=*
 /FILE='D:\TechnicalAppendix\CorrectionalCensuses\Prison1984.sav'
 /BY id.


RECODE
  s_95 s_90 s_84  (SYSMIS=0)  .
EXECUTE .


*** CREATE A FEW VARIABLES THAT ARE NOT BY YEAR

NUMERIC state (F2.0).
COMPUTE state = state_95.
IF s_95 = 0 state = state_90.
IF (s_95 = 0 & s_90 = 0) state = state_84.

STRING facility (A45).
COMPUTE facility = v7_95.
IF s_95 = 0 facility = v10_90.

STRING Add_95 (A45).
COMPUTE Add_95 = v8_95.

STRING city_95 (A32).
COMPUTE city_95 = v9_95.


*** APPLY DICTIONARY FROM *
	/SOURCE = state_90
	/TARGET = state 
	/NEWVARS.

*** THIS DOESN"T WORK: I"M NOT SURE WHY.  SO DO IT INSTEAD WITH:

VALUE LABELS                                                                
   State 
   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" 
.


*** Pull identifying and important variables to the front

MATCH FILES FILE = * 
	/KEEP id state facility add_95 city_95 S_95 S_90 S_84
		state_95 count_95 adp_95 popcp_95 order_95 ordsm_95 ord_o_95
		state_90 count_90 adp_90 popcp_90 order_90 ordsm_90 ord_o_90
		state_84 count_84 adp_84 popcp_84 order_84 ordsm_84 ord_o_84
		ALL .


SAVE OUTFILE = 'D:\TechnicalAppendix\CorrectionalCensuses\Prison1984-1995.sav' .