04-07-2012 01:21 PM
I am on a mission to create a Dashboard using Base SAS and SAS/Graph. I am VERY new to SAS and have no experience creating a Dashboard. That being said, this is what I’m looking for…..
…..I want a dashboard that easily shows performance (visit growth, revenue growth etc) aggregate and (for the client) segmented by property name – I’m looking to display the last 12 months of trends. Also Year/Year (ex. March 12/ March 11 percentage inc/ dec) comparisons and Month/ Month comparisons (March12/Feb 12 % inc/dec) are helpful to see.
I've attached a sample of the data that I need to use.
Again, I am 100% new to this. If any one has any/write sample code to get started with, advice, assistance with the program it will be greatly appreciated.
04-07-2012 02:40 PM
04-07-2012 04:05 PM
You can also create "traditional" dashboard KPIs with PROC GKPI. Example here:
Here's an image of the result:
As with many reporting tasks, most of the work will probably be in the data prep...
04-20-2012 01:07 PM
I was looking at the "snackboard" and I'm wondering how you get multiple outputs from PROC GKPI on the same page?
I assume us used HMTPANEL because I tried using PROC TEMPLATE and that would not work.
Is the complete code available?
Thanks in advance.
04-20-2012 01:39 PM
In my example, I used the SAS Report Builder in SAS Enterprise Guide.
But you can do it programmatically with ODS Layout, as in this example:
04-09-2012 08:32 AM
What you're wanting to do will be a bit challenging for a beginner - but it can be done!
I would suggest that you first focus on determining the individual graphs that best summarize your data, and answer the questions you want to answer from the data. Once you have the individual graphs, then focus on getting them together all on the same page in a dashboard (or, you might even decide that they don't need to be on the same page!)
Here are a few re-usable graphs, created using traditional SAS/Graph, that might be useful in dashboards:
And here are some examples of full-blown dashboards created using SAS/Graph:
And this new SAS/Graph book describes in detail how 2 of the graphs were created: