Click here to see the SAS code.
Click here to see the example.

---------------------------------------------------------------

Using Data From:

http://www.fbi.gov/ucr/cius2006/data/table_08_nc.html



SAS Technology Used:

I used SAS/Access to import the Excel spreadsheet.
I grabbed a list of all the variables (and labels) from dictionary.columns.
I create a drilldown table using "proc report".
I calculate per-capita values via a data step.
I split the data into "quartiles" using "proc rank".
I had to change a few of the city names to match the names in maps.uscity.
I find the lat/long coordinates of each city using SAS/Graph's "proc geocode".
I plot a blank map using "proc gmap", and put dots on the map using SAS/Graph annotate.

Back to Samples Index