A Data Science Central Community
When I was growing up, a big treat on a summer afternoon was to get a Dairy Queen ice cream cone dipped in chocolate. Dairy Queen advertised their treats as scrumpdillyicious, which they were to a seven year old! If you are not aware, SAS ships some shared prompts that you can use with your stored process … and you guessed it … I think they are scrumpdillyicious!
Added by Tricia Aanderud on November 12, 2012 at 6:00am — No Comments
By Steve Overton
Added by Tricia Aanderud on November 1, 2012 at 5:55am — No Comments
The first thing many customers want to do is make their SAS BI Dashboard to look more like "them". They want their organizational branding (their logo, colors, and corporate identity). If that task has fallen on your, here's some guidance about how to accomplish that task.
The SAS BI Dashboard is an Adobe…Continue
Added by Tricia Aanderud on October 18, 2012 at 5:40am — No Comments
SAS Business Intelligence applications use global macro variables to store information about the environment as well as prompt values entered by a user. When developing a Stored Process it is often helpful to review the values of these macro variables. A simple %PUT statement,
%PUT _GLOBAL_ ; , will write a listing of the values of all global macro variables to the log, but the formatting leaves a lot to be desired. This post describes a simple utility macro,…
Added by Tricia Aanderud on October 12, 2012 at 6:29am — No Comments
Steve Overton is working on his SAS Global Forum 2013 paper idea! I don't want to give away his secret - but he wants to show some ways to work with Big Data. First he has to load the big data into his demo system - here's some tricks he has learned.
Do you know some others? Share them!
Added by Tricia Aanderud on October 3, 2012 at 7:02am — No Comments
Steve Overton posted this article:
When troubleshooting data performance problems, IO problems, or simple library connectivity, I use a simple snippet of code to push the data storage to the limits. It is useful because it stresses the data storage component, whether it be a SAS dataset on local file storage or an external database like Oracle, and it provides useful performance metrics. To make it even better, since this is a SAS Macro it can easily be…Continue
Added by Tricia Aanderud on August 8, 2012 at 4:30am — No Comments
Steve Overton shares this tip for SAS Enterprise Guide users and administrators!
A nice feature of SAS Enterprise Guide is the “Files” folder. This provides direct access to the file system where the workspace server is running. You can take advantage of this by configuring a central location where users can store data, SAS…Continue
Added by Tricia Aanderud on June 11, 2012 at 4:44am — No Comments
Perhaps you took my advise a few weeks back and took advantage of the amazing (trumps blare!) SAS Enterprise Guide ability to import MS Excel spreadsheets. However, if your spreadsheet is a little different – then you may run into some issue when you go to import it. For instance, look at this…Continue
Added by Tricia Aanderud on May 30, 2012 at 3:27pm — No Comments
When I was creating the Summary and Detailed reports for the SAS Global Forum paper, I was demonstrating how to link from the weekly chart to the detailed report about the week. On my first try with my Week Filter based on the date value – it just would not work. Eeek! To fix the problem I made a new data item that was a character value. This posts talks about my strategy. [You can read our paper "…Continue
Added by Tricia Aanderud on May 22, 2012 at 4:20am — No Comments
Here’s some usability tricks that I have learned with my SAS Stored Processes to make them more robust and harder to break. Really the out-of-the box prompts provide a lot of functionality that really helps. That’s right – let’s build a better mousetrap!…Continue
Added by Tricia Aanderud on May 16, 2012 at 6:01am — No Comments