Stored Processes

Create and design stored processes like a rock star

Stored Processes
Visual Analytics

It’s Easy to Add a Stored Process to SAS Visual Analytics

Not all data belongs in SAS Visual Analytics – it’s true. You may have situations where you want to filter and zoom on data and then look at the data in another system. Maybe it’s a list of items that the user wants to follow-up on in a different method. If you are using a […]

Read More
5a46377r library of congress truck overturn
BI Tools
Stored Processes

Working with Large Prompt Population Lists

In my last post, I warned you about hooking up your huge dataset to a dynamic prompt.  Impending disaster, user unhappiness and worst of all – rework!  Ahhhh the horror of it all!!! I wish I knew a way to tell you when the dataset was too large for the dynamic prompt, but it is […]

Read More
sas dynamic prompts
BI Tools
Stored Processes

Which population method should I use for my SAS prompt?

During our Debugging and Tuning SAS Stored Processes session, an attendee asked “Why would I choose a dynamic versus static prompt for my stored process?” It was a good question because the choice might make a difference in the stored process speed. Here’s some guidelines. What are the different Population Methods? Stored Processes take user […]

Read More
Coding & Data
Stored Processes

Building a SAS Stored Process Log

As a SAS stored process developer, a question sometimes pokes its way into my head: “Are people using the stored processes I write?”  In fact, really I have four questions: What stored processes are being used?  Who is using them? When are they being used? How are they using them? I realized what I’ve been missing. […]

Read More
1636r_library_of_congress_Karmi_mystery_india
Stored Processes

SAS Stored Process: Dealing with Disappearing Results

The world needs magicians or illusionist.  I love watching illusions.  When I was at the SAS Professional Forum in the UK, there was a illusionist who just knew one card trick after another. Even when he seemed to mess up, he would then point to the card box and say, “Oh your card must be […]

Read More