Tag: Stored Processes

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: 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….

Use OLAP data sources from SAS Stored Processes

So are you now dreaming big? Coming up with other ideas for how SAS Stored Processes can be leveraged in your installation of SAS? As I mentioned in last week’s post, you could use OLAP cubes as a data source for your SAS Stored Process. Here is how I …

I have doubts

One of my new work friends says this frequently. But the statement is lost in his translation from Portuguese, it is not that he does not believe me, it is just that he has questions about how things happen so he can learn. I debate on which version of…

Any SAS program can become a SAS Stored Process

Questions (or search strings) lead people to my blog or my email box on a daily basis and many of these are related to what SAS Stored Processes can or cannot do. Can a SAS Stored Process query an RDBMS? Can a SAS Stored Process create a data table? Co…