get file = 'Directory:\Path\offense segment.sav'.

*Provide labels for the weapon variables

value labels weapon1 weapon2 weapon3
 '11' 'Firearm (type not stated)'
 '12' 'Handgun'
 '13' 'Rifle'
 '14' 'Shotgun'
 '15' 'Other Firearm'
 '20' 'Knife/Cutting Instrument'
 '30' 'Blunt Object'
 '35' 'Motor Vehicle'
 '40' 'Personal Weapons'
 '50' 'Poison'
 '60' 'Explosives'
 '65' 'Fire/Incendiary Device'
 '70' 'Drugs/Narcotics/Sleeping Pills'
 '85' 'Asphyxiation'
 '90' 'Other'
 '95' 'Unknown'
 '99' 'None'.
 
*Recode weapons into categories for table and provide labels

RECODE
  weapon1 
  ('11'=1)  ('12'=1)  ('13'=1)  ('14'=1)  ('15'=1)  ('20'=2)  ('30'=2)
  ('35'=2)  ('40'=3)  ('50'=2)  ('60'=2)  ('65'=2)  ('70'=2)  ('85'=2)
  ('90'=2)  ('95'=6)  ('99'=7)  INTO  wpn1_cat .

RECODE 
 weapon2 
  ('11'=1)  ('12'=1)  ('13'=1)  ('14'=1)  ('15'=1)  ('20'=2)  ('30'=2)
  ('35'=2)  ('40'=3)  ('50'=2)  ('60'=2)  ('65'=2)  ('70'=2)  ('85'=2)
  ('90'=2)  ('95'=6)  ('99'=7)  INTO  wpn2_cat .

RECODE
  weapon3 
  ('11'=1)  ('12'=1)  ('13'=1)  ('14'=1)  ('15'=1)  ('20'=2)  ('30'=2)
  ('35'=2)  ('40'=3)  ('50'=2)  ('60'=2)  ('65'=2)  ('70'=2)  ('85'=2)
  ('90'=2)  ('95'=6)  ('99'=7)  INTO  wpn3_cat .


VARIABLE LABELS 
   wpn1_cat 'Weapon 1 Categories'
   wpn2_cat 'Weapon 2 Categories'
   wpn3_cat 'Weapon 3 Categories'.

value labels wpn1_cat wpn2_cat wpn3_cat 
  1 'Firearms'
  2 'Dangerous Weapons'
  3 'Personal Weapons'
  6 'Unknown'
  7 'None'.

*Recode offenses into category for table

RECODE
  off_code ('09A'=1) ('100'=2) ('11A'=3) ('11B'=4)  ('11C'=4)  ('11D'=4) ('120'=5) ('13A'=6)  INTO off_cat.

variable lables off_cat 'Violent Offense Categories'.
value labels off_cat
   1 'Murder'
   2 'Kidnaping/Abduction'
   3 'Forcible Rape'
   4 'Other Forcible Sex Offenses'
   5 'Robbery'
   6 'Aggravated Assault'.

*Build the weapon category variable to include combination of weapons

IF (wpn1_cat = 1 & SYSMIS(wpn2_cat) & SYSMIS(wpn3_cat)) wpn_cat = 1 .
IF (wpn1_cat = 1 & wpn2_cat = 1 & SYSMIS(wpn3_cat)) wpn_cat = 1 .
IF (wpn1_cat = 1 & wpn2_cat = 1 & wpn3_cat = 1) wpn_cat = 1 .

IF (wpn1_cat = 2 & SYSMIS(wpn2_cat) & SYSMIS(wpn3_cat)) wpn_cat = 2 .
IF (wpn1_cat = 2 & wpn2_cat = 2 & SYSMIS(wpn3_cat)) wpn_cat = 2 .
IF (wpn1_cat = 2 & wpn2_cat = 2 & wpn3_cat = 2) wpn_cat = 2 .

IF (wpn1_cat = 3 & SYSMIS(wpn2_cat) & SYSMIS(wpn3_cat)) wpn_cat = 3 .
IF (wpn1_cat = 3 & SYSMIS(wpn2_cat) & SYSMIS(wpn3_cat)) wpn_cat = 3 .
IF (wpn1_cat = 3 & SYSMIS(wpn2_cat) & SYSMIS(wpn3_cat)) wpn_cat = 3 .

IF (wpn1_cat = 1 & (wpn2_cat = 2 |  wpn3_cat =  2 | wpn2_cat = 3 |  wpn3_cat =
   3)) wpn_cat = 4 .
IF (wpn2_cat = 1 & (wpn1_cat = 2 |  wpn3_cat =  2 | wpn1_cat = 3 |  wpn3_cat =
   3)) wpn_cat = 4 .
IF (wpn3_cat = 1 & (wpn2_cat = 2 |  wpn1_cat =  2 | wpn2_cat = 3 |  wpn1_cat =
   3)) wpn_cat = 4 .

IF (wpn1_cat = 2 | wpn1_cat = 3 | wpn1_cat = 6) & (wpn2_cat = 2 |  wpn3_cat =  2 | wpn2_cat = 3 |  wpn3_cat =
   3 | wpn2_cat = 6 | wpn3_cat = 6) wpn_cat = 5 .


IF (wpn1_cat = 6 & SYSMIS(wpn2_cat) & SYSMIS(wpn3_cat)) wpn_cat = 6 .

IF (wpn1_cat = 7 & SYSMIS(wpn2_cat) & SYSMIS(wpn3_cat)) wpn_cat = 7 .

value labels wpn_cat 
  1 'Firearms'
  2 'Dangerous Weapons'
  3 'Personal Weapons'
  4 'Firearms with Dangerous and/or Personal Weapons'
  5 'Other Weapon Combinations'
  6 'Unknown'
  7 'None'.

EXECUTE .

* Now create the table.

CROSSTABS
  /TABLES=off_cat  BY wpn_cat
  /FORMAT= AVALUE TABLES
  /CELLS= COUNT.