*Larceny, Value of Stolen Property.

GET FILE='Directory\Path\NIBRS offense segment.sav'.
SELECT IF (offense GE 160 and offense LE 167).
SORT CASES BY ori inc_num offense.
COMPUTE dupe = 1.
IF (ori = lag(ori) and
   inc_num = lag(inc_num))dupe = lag(dupe) + 1.
SELECT IF dupe = 1.
SAVE OUTFILE='Directory\Path\larceny offense segment.sav'/KEEP =
   ori inc_num offense dupe.
GET FILE='Directory\Path\NIBRS property segment.sav' / KEEP =
  ori inc_num losstype p_desc p_valu.
SORT CASES BY ori inc_num.
VALUE LABELS
 losstype
  '1' 'None'
  '2' 'Burned'
  '3' 'Counterfeited/forged'
  '4' 'Destroyed/damaged/vandalized'
  '5' 'Recovered'
  '6' 'Seized'
  '7' 'Stolen/etc.'
  '8' 'Unknown'
 / p_desc
 '01' 'Aircraft'
 '02' 'Alcohol'
 '03' 'Automobiles'
 '04' 'Bicycles'
 '05' 'Buses'
 '06' 'Clothes/Furs'
 '07' 'Computer Hardware/Software'
 '08' 'Consumable Goods'
 '09' 'Credit/Debit Cards'
 '10' 'Drugs/Narcotics'
 '11' 'Drug/Narcotic Equipment'
 '12' 'Farm Equipment'
 '13' 'Firearms'
 '14' 'Gambling Equipment'
 '15' 'Heavy Construction/Industrial Equipment'
 '16' 'Household Goods'
 '17' 'Jewelry/Precious Metals'
 '18' 'Livestock'
 '19' 'Merchandise'
 '20' 'Money'
 '21' 'Negotiable Instruments'
 '22' 'Nonnegotiable Instruments'
 '23' 'Office-type Equipment'
 '24' 'Other Motor Vehicles'
 '25' 'Purses/Handbags/Wallets'
 '26' 'Radios/TVs/VCRs'
 '27' 'Recordings-Audio/Visual'
 '28' 'Recreational Vehicles'
 '29' 'Structures-Single Occupancy Dwellings'
 '30' 'Structures-Other Dwellings'
 '31' 'Structures-Other Commercial/Business'
 '32' 'Structures-Industrial/Manufacturing'
 '33' 'Structures-Public/Community'
 '34' 'Structures-Storage'
 '35' 'Structures-Other'
 '36' 'Tools'
 '37' 'Trucks'
 '38' 'Vehicle Parts/Accessories'
 '39' 'Watercraft'
 '77' 'Other'
 '88' 'Pending Inventory'
 '99' 'Special Category'
 '00' 'Default'.
SAVE OUTFILE='Directory\Path\larceny property segment.sav'.
GET FILE='Directory\Path\larceny offense segment.sav'.
MATCH FILES /TABLE=*
 /FILE='Directory\Path\larceny property segment.sav'
 /BY ori inc_num.
SELECT IF (offense ge 160 and losstype = '7').
TEMPORARY.
  VARIABLE LABELS offense '' p_valu '' .
TABLES
  /FORMAT BLANK MISSING('.')
  /OBSERVATION= p_valu
  /GBASE=CASES
  /TABLE=offense  BY p_valu
  /STATISTICS
  mean( p_valu 'Average Property Value') 
  /TITLE  'Larceny, Value of Stolen Property'.