*Tips and Shortcuts for working with NIBRS Data

*Converts age to numeric values

recode vic_age ('BB' = .7),('NN' = .1),('NB' = .2)(convert) into v_age.

*Converts offense codes to numeric values

recode arr_off
('200' = 200) ('13A' = 130) ('13B' = 171) ('13C' = 172)
('510' = 510) ('220' = 140) ('250' = 250) ('290' = 290)
('35A' = 350) ('35B' = 351) ('270' = 270) ('210' = 210)
('26A' = 260) ('26B' = 261) ('26C' = 262) ('26D' = 263)
('26E' = 264) ('39A' = 390) ('39B' = 391) ('39C' = 392)
('39D' = 393) ('09A' = 90) ('09B' = 198) ('09C' = 199)
('100' = 190) ('23A' = 160) ('23B' = 161) ('23C' = 162)
('23D' = 163) ('23E' = 164) ('23F' = 165) ('23G' = 166)
('23H' = 167) ('240' = 150) ('370' = 370) ('40A' = 400)
('40B' = 401) ('120' = 120) ('11A' = 110) ('11B' = 180)
('11C' = 181) ('11D' = 182) ('36A' = 360) ('36B' = 361)
('280' = 280) ('520' = 520)into arroff.


*Creates person, property, and society offense groups

RECODE msioff (90 = 1)(110 = 2) (120 = 3)
(130 = 4)(140 = 5)(160 thru 167 = 6)(150 = 7)
(else = 8) into index.
value labels index 1 'Murder and Nonnegligent Manslaughter'
6 'Larceny'
7 'Motor Vehicle Theft'
3 'Robbery'
2 'Forcible Rape'
4 'Aggravated Assault'
5 'Burglary'
8 'All other offenses'.
recode index (1 thru 4 = 1)(5 thru 7 = 2)(else = 3)into msoffgp.
value labels msoffgp 1 'Person Offenses' 2 'Property Offenses' 3 'Other Offenses'.


*Creates age groups

RECODE v_age (.1 thru 17 = 1)
(18 thru 24 = 2)
(25 thru 34 = 3)
(35 thru 44 = 4)
(45 thru 54 = 5)
(55 thru 64 = 6)
(65 thru 95 = 7)into vagegrp.
VALUE LABELS vagegrp
1 'Under age 18'
2 '18 thru 24'
3 '25 thru 34'
4 '35 thru 44' 
5 '45 thru 54'
6 '55 thru 64'
7 'Age 65 or older'.
VARIABLE LABELS vagegrp 'Victim Age Group'.


*Groups offense times

DO IF (rptdate = ‘ ‘).
RECODE inc_hr (0 thru 5 = 1)
(6 thru 11 = 2)
(12 thru 17 = 3)
(18 thru 23 = 4)into qutrday.
END IF.
value labels qutrday 1 'Midnight to 5 a.m.'
2 '6 a.m. to 11a.m.'
3 'Noon to 5 p.m.'
4 '6 p.m. to 11 p.m.'.