Tag: Stored Process Tips

Three of the Most Common SAS Stored Process Errors

SAS Stored Process LET Statement

If you want to learn how to create a stored process at the SAS Global Forum 2013, then make sure you attend the “Building Your First Stored Process” Hands On workshop that Angela and are hosting on Wednesday morning.  We will show you how to build a three different stored …

The post Three of the Most Common SAS Stored Process Errors appeared first on Business Intelligence Notes for SAS® BI Users. Written by .

Make Your Selection Group Prompt More User Friendly

stored process pox at the sas global forum 2013

Angela and I spent Sunday morning putting the finishing touches on our SAS Global Forum video, Selection Group Prompts with SAS® Stored Processes: More Power, Less Programming.  While at the conference, just stop by the SAS Demo area, where the posters are displayed, to see the video. The video features a …

The post Make Your Selection Group Prompt More User Friendly appeared first on Business Intelligence Notes for SAS® BI Users. Written by .

SAS Stored Processes: Querying a Stored Process from Excel without the Add-In

Stig Eide

What do I have in common with a guy in Norway?  Well, if you look at my last name Aanderud – you might think he is a family member.  Turns out Stig Eide and I both use SAS Stored Processes to solve issues!  Recently this SAS platform administrator asked if he …

The post SAS Stored Processes: Querying a Stored Process from Excel without the Add-In appeared first on Business Intelligence Notes for SAS® BI Users. Written by .

Don’t worry about Your Web Report Studio Style When Including a Stored Process

Web Report Studio Style Change

When you need to add or link a stored process  to your Web Report Studio report, you might be worried that it will not look the same.  For instance – here’s a simple stored process that I created where I declare the style as Banker.  [You can also use a SAS supplied …

The post Don’t worry about Your Web Report Studio Style When Including a Stored Process appeared first on Business Intelligence Notes for SAS® BI Users. Written by .

SAS Stored Process: Debugging from the URL

Here’s an excerpt from “The 50 Keys to Learning SAS Stored Processes” book, which is 20% off until Dec 31. When Bad Things Happen to Good Stored Processes When the stored process fails, a standard error message appears with a button…

SAS Stored Process: Shake, Rattle, and a lil’ DelGobbo Style

One of the great things about attending user conferences such as WUSS is that you get to meet all kinds of fun and interesting people.  Vince DelGobbo is a witty, smart, and clever SAS developer, who also happens to work at SAS Institute.  Vince work…

SAS Stored Process: Benefits of Minimalist Programming

Minimalism 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 process, SAS writes the source code somewhere (see Tricia’s post on where the code is stored).  Typically you enter the source code in the stored process wizard.  I am now in the habit of typing just one %INCLUDE statement in the source code, and I end up with a stored process window that looks like below.  I use the /source2 option to make sure the included code is written to the log.  Minimalist Stored Process The full stored process source code ends up as below, because SAS adds a bit of wrapper code: Minimalist Stored Process: Source Code The main code is DoSomething.sas.  It has the usual DATA steps, PROC steps,  macro calls, maybe even %INCLUDE statements to call other other sub-modules. Minimalist Stored Process: Main Code So what are the benefits? You can store the main SAS code (DoSomething.sas) wherever you want.  I’ve been writing SAS code for MUCH […]

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…

[Read the full article at the Http://www.bi-notes….