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

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

For this example, I collected information about a lot of NC campgrounds,
mainly from http://www.landbigfish.com/campgrounds/list.cfm/start.4601.htm.
I also got info from http://camping.about.com/od/cgwebpagesnc/North_Carolina_Campgrounds_with_Web_pages.htm.
And then I updated it in June 2009 with additional campgrounds from 
http://www.americaonwheels.com/NorthCarolina/, 

I copy-n-pasting and/or re-typed the info into a spreadsheet (therefore there might be some errors).  

I then used "proc import" to read the spreadsheet into a SAS data set.

I then parse out some info from the address field(s), and use the 
zipcode to lookup the longitude/latitude in the sashelp.zipcode
data set.

With the longitude/latitude, I can annotate markers onto maps.county.
(To annotate markers in the correct location, the annotate & map must
be in the same coordinate system, and you must 'gproject' them 
together).

I add a few extra special-touches, such as annotating a black shadow
behind the map, and also I annotate strips of color benind the map to 
give it a shaded/gradient look.  Then I annotate tree images along the 
bottom edge of the gif (the trees have a transparent background, so 
they "blend in" with the gradient background of my map - this support 
of transparency is a new v9.2 feature).

Since there can be multiple campgrounds per city, each marker 
represents a city, and when you click on the marker it jumps to an
html "anchor" where there's a table showing all the campgrounds in
that city - you can then click on the campground you want, to launch
a google search for info about that campground.  I inserted a lot of
space between the tables, so that you would only see the table for
one city (ie, the city you have drilled-down on) at a time.




Back to Samples Index