This Treemap was created using SAS/Graph proc gmap, and a custom map data set created using some macros I wrote. Click here to see details on how the macros work. Click here to see the SAS code that calls the macros (wake.sas) Click here to see other SAS code for drilldowns (wake_elementary.sas) Click here to see other SAS code for drilldowns (wake_middle.sas) Click here to see other SAS code for drilldowns (wake_high.sas) Click here to see the example. This is another multi-level Treemap. The first level is the type of School (Elementary, Middle, and High), and the 2nd level is the individual schools (with further drilldown to detailed tables). The size of boxes represent total salary for that group, and the color of the boxes represents the average salary for that group. One difference in this map from most others, is that this one allows you to *drilldown*! I used the html title= charttip/flyover-text, and also coded in html href= drilldowns. The drilldown has the urls of Treemap I have pre-created (one per type of School). Once you drilldown to the 2nd level of treemaps, then the drilldown from here is to a table of detailed data for that school (I use a drilldown to an html anchor on the same page for these tables). The drilldowns would have been much easier to do though sas/intrnet, where I could generate each drilldown Treemap on-the-fly when the user clicks ... but in order to make this demo easy to carry to other systems, I did not want to require everyone to install sas/intrnet, and have the server running ... therefore I pre-created all the drilldown maps and saved them on the disk). ----- Here are links to the website where I got this public-domain data: School Salary Data Wake County Salary Data Other County Data ----- Back to Samples Index