*Creates the example tables to look at the location of drug offenses.

USE ALL.
COMPUTE filter_$=(off_code='35A' | off_code='35B').
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

value labels off_loc
'01' 'Air/Bus/Train Terminal' '02' 'Bank' '03' 'Bar/Nightclub' '04' 'Church/Synagogue/Temple'
'05' 'Commercial/Office Building' '06' 'Construction Site' '07' 'Convenience Store'
'08' 'Department Store' '09' 'Drug Store/Doctors Office/Hospital' '10' 'Field/Woods'
'11' 'Government/Public Building' '12' 'Grocery' '13' 'Highway/Road/Alley'
'14' 'Hotel/Motel' '15' 'Jail/Prison' '16' 'Lake/Waterway' '17' 'Liquor Store'
'18' 'Parking Lot/Garage' '19' 'Rental Storage Facility' '20' 'Residence/Home'
'21' 'Restaurant' '22' 'School/College' '23' 'Service/Gas Station' '24' 'Specialty Store' 
'25' 'Other/Unknown'.

frequencies
variables=off_loc.

IF (crimact1 = 'U' | crimact1 = 'B' | crimact2 = 'U' | crimact2 = 'B' |
  crimact3 = 'U' | crimact3 = 'B') type = 1 .
IF (crimact1 = 'D' | crimact2 = 'D' | crimact3 = 'D') type = 2 .
EXECUTE .

value labels type
1 'User' 2 'Dealer'.

SORT CASES BY type .
SPLIT FILE
  SEPARATE BY type .

frequencies
variables=off_loc.