Tag: Stored Processes

SAS EG and Stored Processes: 3 Tips for Using Options

There are some helpful options you can set in SAS Enterprise Guide to make your day-to-day coding tasks a little quicker. Some of these tasks can impact stored processes you create from tasks instead of coding. SAS Enterprise Guide Options From the Tools > Options menu you can preset options such as footer text and default SAS code that you want run before or after a task executes. Sometimes this can be more helpful than other times. Tip #1 – Adding a Default Footer You can add a default footer or header to all of your SAS generated reports. If you are using the SAS Tasks, SAS automatically adds whatever you have preset in the Options.  If you use SAS functions or macro variables your reports and graphs will appear more customized. To set  a default footer for your SAS Enterprise Guide reports and graphs, do this: From the Tools>Options menu, select the Tasks General pane. In the Default footnote text for task output field, type your text.  For instance, I am using the default time and date to indicate the last time the report was updated.  Note! The date() function returns when the SAS Enterprise Guide session was started […]

SAS BI: Looking at Google Analytics for Popular Blog Topics

This past week I have been studying the Google Analytics data to determine the best topics to discuss in the upcoming month and to prepare the SAS Glo Fo 2012 conference. Google Analytics allows me to measure which posts get the most hits when posted and continue to be popular or referenced. I’ll unveil my little known, but highly coveted analytics process. How’s that for some hype? Getting the Google Analytics Data In a past article, I discussed how I extracted the data from Google Analytics using Excellent Analytics. The following figure shows my query in the Excellent Analytics tool, the data results, and the results in SAS Enterprise Guide. The data consists of the date, post path and title (with URL), source (how person came to site), and visitor type. It’s probably obvious why I would want the date, post, and source but what is not so obvious is visitor type. Visitor Type allows me analyze what topics bring new visitors to the site as well as the topics that retain visitors. Cleaning Up the Data My original plan was to use MS Excel to complete this analysis since I thought it would be simple. However, I realized that […]

SAS Global Forum: Is Google Analytics and SAS BI a good subject?

I’m really excited, Angela and I were invited to speak at the SAS Global Forum in Orlando in April. We were asked to talk about the SAS BI package and we have narrowed down our topic to SAS Information Map Studio, SAS Web Report Studio, and, if time allows, the SAS Information Delivery Portal.  The point of the presentation is learning about the SAS BI clients – getting the data has proved to be a journey of it’s own. Step 1: Need some interesting data … The hardest part of preparing a teaching presentation is find data that presents some mystery and allows you to tell a story that resonates. Right now the leading topic is  along the lines of “How do you let people know you have a book out there?  How do you build excitement?”  For us, building a companion website (this blog) that gave the users an idea of the book content was our answer.  Plus the website would be a continuation of the book information for the users.   The next question is – “How do you know it’s working?” Using the data that Google Analytics collects for this blog, I have been researching what kind of […]

SAS Prompts: When do you use a Variable Prompt?

If you have spent anytime building SAS  prompts for a stored process, then you might have noticed the prompts near the bottom of the list and wondered how anyone would use those or even need them. In a previous post, I showed you how to use the data l…

SAS BI: Conditional Highlighting for Reports

Conditional highlighting, also referred to as traffic lighting, helps report consumers quickly recognize when the data is showing the desired trends based on their targets.  Today I’ll talk about the color choices for the highlighting from MS Ex…

Web Report Studio: Souped up Dashboard Speedometers, Sliders, and Dials

Sometimes SAS Web Report Studio needs some dashboard dials and sliders that seems like mission impossible for you. However, add a stored process with the trusty ole’ SAS GKPI procedure to bring the dashboard features to your local report. I know you are wondering – “What is this special magical procedure of which she speaks?” Oh you are about to find out my precious little SAS geeks. Adding Dashboard Goodies to SAS Web Report Studio You can easily add sliders, dials, and speedometers to your report using a stored process and the SAS GKPI procedure. In the following figure, the report contains a sample of the different gadgets you can add.  Plus notice – there is not any data (cube, info map) being used – it’s all stored processes.    Show me the Code!   All of the code was based on the examples from the GKPI procedure SAS documentation.  I’m only going to show how to create the one for the Avg Fix Response Time because there are just a few fine points to creating an registering the stored process. Otherwise, I basically used the examples from the SAS documentation and I think it’s easy enough to figure out.   […]

Stored Process Outputs Data without a Report

You can do more with SAS Stored Processes than just create reports.  These little suckers are packed full of power and the only limit is your imagination (and libraries where you  have write access!)  In this post, you will learn how to use a store…