Subscribe to DSC Newsletter

Tricia Aanderud's Blog (35)

Things to Consider for Mobile BI Design

Rather it's the wave of the future or just a passing fad,  if you are designing information for the mobile BI users then this change applies to you!  There's a simple reason - what will your fancy report look like on a teeny-tiny, itty-bitty tablet? Cramped? Sliding off the page? Not ready for prime time?   [Read more about mobile BI predictions in my Mobile BI Is Arriving Soon... It Could…


Added by Tricia Aanderud on August 15, 2013 at 10:30am — No Comments

Push SAS Further with JQuery and AJAX - It's Easy!

In the Jurassic SAS in the BI/EBI World blog, Don Henderson shows fun and cool ways to push SAS a little further, which is using SAS Server Pages, JQuery and AJAX.

Check out his startling and beautiful results.  …


Added by Tricia Aanderud on July 30, 2013 at 2:41am — No Comments

3 Tips for Escaping Upper Hell (aka Slow Connections with Large Data)

Ever find yourself waiting for your data to appear and you start wondering if you are paying for sins from a past life?  Dante must have been thinking of this situation as he created his Circles of Hell.  There is no way the agony of waiting for data to appear with a looming deadline did not make his list!

Often it seems like the closer the deadline, the slower the connection.  When working with data locally, the data appears…


Added by Tricia Aanderud on June 4, 2013 at 5:23am — No Comments

View a SAS table in Excel using a Web Query and a Stored Process

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…


Added by Tricia Aanderud on February 21, 2013 at 5:30am — No Comments

Does your SAS code know what time it is? It’s %NOW

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…


Added by Tricia Aanderud on December 20, 2012 at 4:22am — No Comments

Put all Your Code in an Elephant Trunk!

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 — No Comments

SAS Prompt Framework: SAS Shared Prompts are Scrumpdillyicious for a Stored Process!

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 — No Comments

SAS BI Dashboard: Putting Adding Branding to the Dashboard!

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…


Added by Tricia Aanderud on November 5, 2012 at 5:12am — No Comments

SAS Administration: Fetch Big Data Faster Across ODBC

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…


Added by Tricia Aanderud on November 1, 2012 at 5:55am — No Comments

SAS Stored Process: Using Alternating Background Color with PROC REPORT

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…


Added by Tricia Aanderud on October 30, 2012 at 6:33am — No Comments

BI Dashboard: Flex Theme Designer Makes it Personal

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…


Added by Tricia Aanderud on October 18, 2012 at 5:40am — No Comments

SAS Code: Show the Values of All Macro Variables in Your SAS Session

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

Working with Big Data in SAS BI

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 — No Comments

SAS Portal and BI Dashboard: Customizing the Tabs

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…


Added by Tricia Aanderud on September 27, 2012 at 7:30am — No Comments

SAS Stored Process: Benefits of Minimalist Programming


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 — No Comments

Can Your System Win the Gold?

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…


Added by Tricia Aanderud on August 8, 2012 at 4:30am — No Comments

Easy Customizations for SAS Portal and SAS Web Report Studio

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…


Added by Tricia Aanderud on August 1, 2012 at 5:15am — No Comments

Web Report Studio: Recognize these 2 Gotchas?

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…


Added by Tricia Aanderud on July 23, 2012 at 6:00am — No Comments

User Groups: Will I see You at the SAS UK Professional Convention?

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…


Added by Tricia Aanderud on July 8, 2012 at 9:00am — No Comments

SAS Stored Process: Ignore the Log at Your Own Peril

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…


Added by Tricia Aanderud on July 5, 2012 at 5:36am — No Comments

On Data Science Central

© 2021   TechTarget, Inc.   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service