* The following syntax is provided as an example of using NIBRS data to examine race, crime and arrest data. Please be sure * to review each step and it's output to ensure that your information matches the expected output. ****************************************************************************************. *Merge the segment five data for 1993 - 2000. Select out cases with offender numbers 1 or greater. GET FILE='Path:\1993 Segment 5 Data.sav'. ADD FILES FILE='Path:\1994 Segment 5 Data.sav' /FILE='Path:\1995 Segment 5 Data.sav' /FILE='Path:\1996 Segment 5 Data.sav' /FILE='Path:\1997 Segment 5 Data.sav' /FILE='Path:\1998 Segment 5 Data.sav' /FILE='Path:\1999 Segment 5 Data.sav' /FILE='Path:\2000 Segment 5 Data.sav'. EXECUTE. SAVE OUTFILE='Path:\RSEG5.sav'. SELECT IF (OFFNNUM GE 1). EXECUTE. SAVE OUTFILE='Path:\RSEG5.sav'. ****************************************************************************************. *Merge the segment two data for 1993 - 2000. GET FILE='Path:\1993 Segment 2 Data.sav'. ADD FILES FILE='Path:\1994 Segment 2 Data.sav' /FILE='Path:\1995 Segment 2 Data.sav' /FILE='Path:\1996 Segment 2 Data.sav' /FILE='Path:\1997 Segment 2 Data.sav' /FILE='Path:\1998 Segment 2 Data.sav' /FILE='Path:\1999 Segment 2 Data.sav' /FILE='Path:\2000 Segment 2 Data.sav'. EXECUTE. SAVE OUTFILE='Path:\RSEG2.sav'. SORT CASES BY ori incident. SAVE OUTFILE='Path:\RSEG2.sav'. ****************************************************************************************. *Create the index to match files. AGGREGATE OUTFILE=* /break ORI INCIDENT/COUNT=N. FREQ COUNT. SAVE OUTFILE='Path:\INDEX.sav'. ********************************************************************************************. *Match the index file with Segment 2 to select cases. GET FILE='Path:\INDEX.sav'. SORT CASES BY ori incident. SAVE OUTFILE='Path:\INDEX.sav'. GET FILE='Path\RSEG2.sav'. MATCH FILES /FILE= * /TABLE 'Path:\INDEX.sav' /BY ori incident. EXECUTE. FREQ COUNT. SELECT IF (COUNT GE 1). FREQ COUNT. SAVE OUTFILE='Path\RSEG2A.sav'. ***************************************************************************************. *In indexed Segment 2 file, create a seriousness rating. NUMERIC RANKING (F2.0). IF (OFFENSE='09A') RANKING=1. IF (OFFENSE='09B') RANKING=2. IF (OFFENSE='100') RANKING=3. IF (OFFENSE='11A') RANKING=4. IF (OFFENSE='11B') RANKING=5. IF (OFFENSE='11C') RANKING=6. IF (OFFENSE='120') RANKING=7. IF (OFFENSE='13A') RANKING=8. IF (OFFENSE='13B') RANKING=9. IF (OFFENSE='11D') RANKING=10. IF (OFFENSE='13C') RANKING=11. IF (OFFENSE='210') RANKING=12. IF (OFFENSE='36B') RANKING=13. IF (OFFENSE='36A') RANKING=14. IF (OFFENSE='200') RANKING=15. IF (OFFENSE='240') RANKING=16. IF (OFFENSE='220') RANKING=17. IF (OFFENSE='250') RANKING=18. IF (OFFENSE='270') RANKING=19. IF (OFFENSE='510') RANKING=20. IF (OFFENSE='26A') RANKING=21. IF (OFFENSE='26B') RANKING=21. IF (OFFENSE='26C') RANKING=21. IF (OFFENSE='26D') RANKING=21. IF (OFFENSE='26E') RANKING=21. IF (OFFENSE='23A') RANKING=22. IF (OFFENSE='23B') RANKING=22. IF (OFFENSE='23C') RANKING=22. IF (OFFENSE='23D') RANKING=22. IF (OFFENSE='23E') RANKING=22. IF (OFFENSE='23F') RANKING=22. IF (OFFENSE='23G') RANKING=22. IF (OFFENSE='23H') RANKING=22. IF (OFFENSE='280') RANKING=23. IF (OFFENSE='290') RANKING=24. IF (OFFENSE='35A') RANKING=25. IF (OFFENSE='35B') RANKING=26. IF (OFFENSE='520') RANKING=27. IF (OFFENSE='39A') RANKING=28. IF (OFFENSE='39B') RANKING=28. IF (OFFENSE='39C') RANKING=28. IF (OFFENSE='39D') RANKING=28. IF (OFFENSE='370') RANKING=29. IF (OFFENSE='40A') RANKING=30. IF (OFFENSE='40B') RANKING=30. EXECUTE. FREQ RANKING. VALUE LABELS RANKING 1 'Murder & non-negligent homicide' 2 'Negligent manslaughter' 3 'Kidnapping/abduction' 4 'Forcible rape' 5 'Forcible sodomy' 6 'Sexual assault with an object' 7 'Robbery' 8 'Aggravated assault' 9 'Simple assault' 10 'Forcible fondling' 11 'Intimidation' 12 'Extortion/blackmail' 13 'Statuatory rape' 14 'Incest' 15 'Arson' 16 'Motor vehicle theft' 17 'Burglary' 18 'Counterfeiting/forgery' 19 'Embezzlement' 20 'Bribary' 21 'Fraud' 22 'Larceny theft' 23 'Stolen property offenses' 24 'Vandalism/destruction of property' 25 'Drug/narcotic violations' 26 'Drug equipment violations' 27 'Weapons law violations' 28 'Gambling' 29 'Pornography/obscene material'. SAVE OUTFILE='Path\RSEG2A.sav'. *************************************************************************************. *Determine the lowest ranking offense for each incident and match to Segment 5 data. SORT CASES BY ori incident ranking. SAVE OUTFILE='Path\RSEG2A.sav'. AGGREGATE OUTFILE=* /BREAK ori incident /RANKING=MIN(ranking) /OFFENSE = FIRST (offense)/ATTEMPT=FIRST (attempt)/USED1 = FIRST (used1)/USED2= FIRST (used2) /USED3 = FIRST (used3)/LOCATION = FIRST (location)/ENTRIES = FIRST (entries)/EMETHOD = FIRST (emethod) /CRIMACT1=FIRST(crimact1)/CRIMACT2=FIRST(crimact2)/CRIMACT3=FIRST (crimact3)/WEAPON1= FIRST (weapon1) /WEAPAUT1 = FIRST (weapaut1)/WEAPON2=FIRST (weapon2)/WEAPAUT2 =FIRST (weapaut2) /WEAPON3 = FIRST (weapon3)/WEAPAUT3 = FIRST (weapaut3)/BIAS = FIRST(bias)//SEGMENT = FIRST (segment) /N_BREAK= FIRST (N_BREAK)/COUNT = FIRST (count)/COUNT2 = FIRST (count2)/COUNT2B=N. SAVE OUTFILE='Path\TBLSEG2B.sav'. GET FILE='Path\RSEG5A.sav'. SORT CASES BY ori incident. SAVE OUTFILE='Path\RSEG5A.sav'. MATCH FILES /FILE= * /TABLE 'Path\TBLSEG2B.sav' /BY ori incident. EXECUTE. SAVE OUTFILE='Path\RSEG5A.sav'. **************************************************************************************. *Create variables in Segment 4 - number of victims under 18. GET FILE='Path\RSEG4A.sav'. SORT CASES BY ori incident. FREQ VICAGE. SELECT IF (VICAGE LT 18). EXECUTE. AGGREGATE OUTFILE=* /BREAK ori incident/agelt18=N. FREQ agelt18. SAVE OUTFILE='Path\TBLSEG4A.sav'. GET FILE='Path\RSEG4A.sav'. MATCH FILES /FILE= * /TABLE 'Path\TBLSEG4A.sav' /BY ori incident. EXECUTE. SAVE OUTFILE='Path\RSEG4A.sav'. ************************************************************************************. *Create variable - number of non-individual victims. FREQ VICTYPE. SELECT IF (VICTYPE NE 'I'). SELECT IF (VICTYPE NE 'U'). EXECUTE. FREQ VICTYPE. AGGREGATE OUTFILE=* /BREAK ori incident/victype1=N. FREQ victype1. SAVE OUTFILE='Path\TBLSEG4B.sav'. GET FILE='Path\RSEG4A.sav'. MATCH FILES /FILE= * /TABLE 'Path\TBLSEG4B.sav' /BY ori incident. EXECUTE. SAVE OUTFILE='Path\RSEG4A.sav'. ************************************************************************************.