* First, recode the property into categories

RECODE
  p_desc
  ('07'=1)  ('17'=2)  ('20'=3)  ('03'=4)  ('05'=4)  ('24'=4)  ('28'=4)
  ('37'=4)  ('21'=5)  ('26'=6)  ('29'=7)  ('30'=7)  ('31'=7)  ('32'=7)
  ('33'=7)  ('34'=7)  ('35'=7)  ('36'=8)  ('38'=9)  (ELSE=10)  INTO  prop_cat
  .
EXECUTE .

value labels prop_cat
  1 'Computer Hard/Software'
  2 'Jewelry/Precious Metals'
  3 'Money'
  4 'Motor Vehicles'
  5 'Negotiable Instruments'
  6 'Radios/TVs/VCRs'
  7 'Structures'
  8 'Tools'
  9 'Vehicle Parts/Accessories'
  10 'Other'.

* Select only the property loss presented in the table

USE ALL.
COMPUTE filter_$=(losstype = '5' | losstype = '6').
VARIABLE LABEL filter_$ "losstype = '5' | losstype = '6' (FILTER)".
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

* Create the table

* Basic Tables.
TABLES
  /FORMAT BLANK MISSING('.')
  /OBSERVATION p_valu
  /FTOTAL $t 'Group Total'
  /TABLES (prop_cat > p_valu +  $t )
  BY (losstype > (STATISTICS) +  $t )
  /STATISTICS
  sum( ) /TITLE  'Value of Property Recovered/Seized'.