Dashboards:Tips for Designing Dashboards with SAS Code
I realize not everyone is using the SAS BI system, but that does not mean that you don’t need to create a dashboard. In BASE SAS, dashboards are created using fairly simple SAS code (GKPI, macros, and ODS). [Remember, you can insert the same PROC GKPI code into Web Report Studio as a stored process if you need a dashboard elements.]
Dr. Christopher Simien, our guest author today, has written a book that shows how to get the most out of simple SAS coding to create dashboards. As far as I know this is the only book dedicated to using SAS code to create a dashboard. As you will see in the following post, Dr. Simien steps you through how to write the code to get the results you want. In his book he discusses the pros and cons of various objects and provides tips for getting the best results.
Designing Dashboards with SAS
I was delighted to get an invitation from Tricia to share a little about my latest book you. I wrote THE DESIGN OF INFORMATION DASHBOARDS USING SAS® when I discovered there was next to no published material on developing SAS code for dashboards beyond a number of short papers at recent SAS Global Forums.
A dashboard organizes and presents large amounts of data, such as current status and historical trends, in an easy to read graphical interface. Dashboards are quickly being adapted across all types of organizations. The book is a nuts and bolts guide to building dashboards using SAS software. The primary audience is SAS programmers charged with developing dashboards for their organization. A secondary audience includes business managers and non-programmers who are just hoping to learn a little more about the potential of the technology.
The first four chapters provide background on the science of information visualization and related concepts. The remaining chapters cover coding and design of dashboards using SAS software. I tried to provide clear, well-structured examples, and show the reader how to quickly and easily construct basic dashboards that are suitable to their unique needs.
SAS users familiar with the basics of SAS software and the fundamentals of SAS/GRAPH® software will be able to make small changes to the sample code contained in the book to design simple dashboards. Advanced users with more extensive knowledge of SAS/GRAPH and the annotate facility will be able to more fully customize the sample code to fit a variety of needs.
Creating a Bullet Graph
I present one of the code samples from the book below. The code is for a bullet graph. Bullet graphs are a type of display that has only been around for a few years. However, it is an excellent way to display rich information in a small footprint. I produced this particular version with the SAS GKPI procedure that is wrapped in a macro.
2. Add GOPTIONS to control how the output is displayed.
3. Enclose the PROC GKPI in a macro so you can use the values set in step 1.
In the book, I provide recommendations for display and present code for two different versions of bullet graphs. Check out the book for other examples of useful performance indicators. You can find the book on sale now at Amazon.com.
Never miss a post!
GetHave the latest BI Notes post in your Inbox when a new post is released! Click here for free subscription. You email address is kept private and you can unsubscribe anytime. Go ahead ... join us! p> <
Latest posts by Tricia Aanderud (see all)
- SAS Add-In for MS Office: Abe Lincoln Sends Glee in a Snowstorm - February 18, 2014
- #SASGF14: You’re Invited to a TweetUp! - February 10, 2014
- SAS Stored Process Dealing with Disappearing Results - January 31, 2014
- More SAS Stored Process Sleight of Hand Tricks - January 29, 2014
- Little Known Secrets from SAS Stored Process Magicians - January 26, 2014