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

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

For you guys on the external web, sorry about this one!
The drilldowns run on our internal SAS/Intrnet server.
You can click to drilldown to the state, and then the county level maps,
and then at the county level you can click on the dots to drilldown to the 
individual college websites (and/or click on the colleges in the table
below the map).

With 6000+ counties in the US, there were just too many of them to 
create static copies of each ahead of time and put them on my website
(On our internal web, SAS/Intrnet generates the maps on-the-fly
when you click on them).

-----

I downloaded the csv data and their sas job to read in the data from here:

IPEDS Data Center:
http://nces.ed.gov/ipeds/datacenter/

Selected "Download Survey Data Files"
http://nces.ed.gov/ipeds/datacenter/DataFiles.aspx

Selected year 2011, Institutional Characteristics
pressed "Continue" button

Downloaded/Extracted the Data File, SAS Program, and Dictionary:
hd2011.csv  hd2011.sas  hd2011.xls

I modified their sas job to use (compress=yes) on the sas data set (reduces the size from 28Mb down to 2.5Mb).
I named the data set hd2011.sas7bdat, and saved it in a permanent libname.

Here's the sas job that read in the data: Click here to see the SAS code.

For this particular map, I subset the data to only contain the continental US.
I combine it with the US map, and 'proc gproject' the two together, and then
separate them apart again.  (This keeps the annotated dots lined up in the right
location).

I use gmap's html= option to tell it to drilldown for each state, based on
the html tags I've encoded into the "myhtml" variable (I build up these values
programmatically, based on the state value).  The drilldown for each state
runs a sas/intrnet job, passing the selected state as a parameter on the URL,
and sas/intrnet runs a job similar to this one, but that only plots the data
for the selected state.  Similarly the state maps have a drilldown to the 
county level.

At the county level, the annotated dots have a drilldown to the school's webpage.
Also, scroll down below the county map to see a table of all the schools in that county,
and you can also drilldown to the school's websites from the table.
Back to Samples Index