Guest Post by Stig Eide
Stig Eide showed me a trick for using the Excel web query to look at SAS data. Very clever trick!
Want to view a SAS table in Excel but you don't have the Add-In for Microsoft Office installed? This post describes an alternative method. Excel has a nice feature where you are allowed to query a web page for data. I will describe how you can set up the query against a stored process, and how to pass parameters.
First, you need… Continue
Added by Tricia Aanderud on February 21, 2013 at 5:30am —
Written By Quentin McMullen
In 1986 the Beastie Boys released their classic debut album, License to Ill, and the last track posed a question: “What’s the time?” The Beasties answered with an anthem, “It’s time to get ill.” I think Peter Crawford, SAS programmer extraordinaire, would have answered more simply. What time is it? It’s %now.
%Now – a Timestamp Macro
%Now generates a timestamp. It’s a simple SAS macro, but despite its simplicity, it… Continue
Added by Tricia Aanderud on December 20, 2012 at 4:22am —
Last week while searching for a code snippet through several folders of information, I realized that the code was still on my old computer ... ugh! One of my weekend projects was to organize my code examples somewhere - I'm going to try Evernote, which I have been using to organize other items. Evernote uses an elephant for it's mascot - because elephants never forget. That's what I need!
Easy to Organize and Find Code…
Added by Tricia Aanderud on December 17, 2012 at 4:34am —
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!
Locating the Shared Prompts
Added by Tricia Aanderud on November 12, 2012 at 6:00am —
After creating a dashboard, the customer asks to have their logo and colors added so their organization branding is available. Using the SAS Flex Theme Designer, you can change the SAS BI Dashboard colors and logos. In this post I showed you some basics for using the SAS Flex Theme Designer… Continue
Added by Tricia Aanderud on November 5, 2012 at 5:12am —
By Steve Overton
On my current “big data” project, I’m connecting SAS to PostgreSQL using the ODBC access engine. At first I was seeing pretty bad performance – specifically I wasn’t able to view the ~2.2… Continue
Added by Tricia Aanderud on November 1, 2012 at 5:55am —
I remember when I began learning how to program using SAS. One of my first tasks was to create a set of reports that listed the trouble tickets from the customer. This was before it was easy to get information from SAS to Excel and the goal was to have the reports on the website so it could be reviewed easily.
All Hail My SAS Heroes!
PROC REPORT results were ugly and hard to read - the manager did not complain but he wasn't impressed. What a breakthrough when I found… Continue
Added by Tricia Aanderud on October 30, 2012 at 6:33am —
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.
What the Heck is the Flex Theme Designer?
The SAS BI Dashboard is an Adobe… Continue
Added by Tricia Aanderud on October 18, 2012 at 5:40am —
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, Continue
%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 —
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!
SAS Administration: Process Data Faster in RDBMS by Buffering the Data in Memory
Added by Tricia Aanderud on October 3, 2012 at 7:02am —
You can customize the SAS Portal and SAS BI Dashboard Web Browser titles in just a few moments. Here’s another branding trick that Kushal Ramani sent to me. He also sent some these branding tricks for Web Report Studio and SAS Portal. For this example, you… Continue
Added by Tricia Aanderud on September 27, 2012 at 7:30am —
SAS stored processes can do a lot. While I haven’t taken on the life of a true minimalist, recently I have come to see the benefits of limiting my stored process source code to just one statement. And the best part of this practice is, I can still do everything I want.
When you create a stored…
Added by Tricia Aanderud on September 20, 2012 at 5:27am —
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 —
Last week I talked about how you could customize the style sheet for Web Report Studio. One reader, Kushal Ramani, a SAS consultant from Epoch Research India, suggested that I list some other items that you can easily change in Web Report Studio and SAS Portal. All of these changes require access to SAS Management Console – so if you don’t… Continue
Added by Tricia Aanderud on August 1, 2012 at 5:15am —
If you aren’t paying close attention to the messages in Web Report Studio, you may run into some puzzling issues. The messages that SAS produces may not be obvious enough if you are expecting a different behavior, thus making troubleshooting a bit difficult.
Gotcha 1: Why Won’t My Changes Save?
This reminder comes from Shri Sastry. She had asked a co-worker to make a simple change to a Web Report Studio and she noticed… Continue
Added by Tricia Aanderud on July 23, 2012 at 6:00am —
This week (July 10-12) the SAS UK Professional Convention takes place at the SAS UK Headquarters ( Marlow, England). I'm hearing there are record numbers for attendance - so it should be a happening gig. Already the Tuesday session has filled up!
Focus is Big Data - There's More Than That!
Here's some highlights and you can find a complete agenda… Continue
Added by Tricia Aanderud on July 8, 2012 at 9:00am —
I love our readers – especially when they have a great idea they want to share. Quentin McMullen, who has been programming in SAS for 15 years, primarily in clinical trials and public health submitted such an idea recently. Several months ago he left a comment asking about checking the log from a stored processes. I didn’t really have a good idea – so he came up with one! Please add your thoughts in the Comments section – he wants feedback from other experts!
Quentin does not have… Continue
Added by Tricia Aanderud on July 5, 2012 at 5:36am —
The SAS BI web clients each have their own link (or URL). When working across many customer sites or even just using my own demo sites – there can be a lot of links to track (BI Dashboard, Portal, WRS, etc). Certainly I can add bookmarks to my browser – but when moving to different systems I found it’s easier to just have a little .HTML file that I can edit as needed.
Set Your BI Toolset Quick Ref Bookmark
If you are not sure what I’m trying to describe – the following… Continue
Added by Tricia Aanderud on June 25, 2012 at 5:07am —
I have been very busy in the past month writing guest post for some of the different blogs that I follow and find interesting. I’ve also been reading some books that I wanted to share with you!
Blogging! Blogging! and More Blogging!
Added by Tricia Aanderud on June 22, 2012 at 6:03am —
While at the SAS Global Forum, someone said to me – “You cannot write code in SAS Enterprise Guide.” It was a little shocking to me that the person thought SAS Enterprise Guide was all wizards, flow diagrams, and magic. After talking to a few other folks I have found that it is a common myth.
News Flash! You can just code in SAS Enterprise Guide! Today I’ll show you how I pull data from Outlook into SAS Enterprise Guide to create a tweet. And I’m just going to… Continue
Added by Tricia Aanderud on June 20, 2012 at 4:54am —