Have you ever submitted a stored process, and instead of the expected output, you saw errors or no output at all? Depending on how you submit the stored process, various logs are available to assist you with debugging. This article provides guidance for understanding which situations call for which logs, where to find each log, and what you should look for in each log.
Tag: Stored Processes
Stored processes were a very popular feature in SAS 9.4. They were used in reporting, analytics and web application development. In Viya, the equivalent feature is jobs. Using jobs the same way as stored processes was enhanced in Viya 3.5. In addition, there is preliminary support for promoting 9.4 stored processes to Viya. In this post, I will examine what is sure to be a popular feature for SAS 9.4 users starting out with Viya.
Last week I provided the steps for how to go on a date, at least by using dynamic prompts in BI Dashboard. Now that you have seen how to create them, lets discuss making them smarter. For this example, the customer is asking for two prompts to affect a single
Don't give up on the dating game. Just because there is no prompt type specifically for dates, it can still be accomplished with some stored process matchmaking. BI Dashboard offers a dynamic prompt indicator which provides the ultimate flexibility in developing prompt based reports and dashboards. The dynamic prompt indicator
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 would
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 this
Wizard Harry Potter makes magic just waving his wand around and shouting out spells. Using SAS Enterprise Guide (and you are welcome to shout out your own commands too) you can create some magic, allowing the Stored Process Wizard to code for you. On Step 2, the "Include code for"
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? Could
Stored process code can exist within the metadata itself for version 9.3 (the benefits of which I discussed earlier). But for all other versions (and as a option in version 9.3) the SAS code is stored as a .sas file within the server's file system (or mapped folder/drive structure). When editing
The date prompt from SAS Prompt Framework provides the options of single selection or a range, however what if you need to select multiple individual dates such as Monday (May 28), Wednesday (May 30), and Friday (June 1) of last week? There are a few alternatives to accomplishing this. Option
What if you would like to make a copy of an existing stored process to test out your changes before making them live? The copy command is available from within SAS Management Console or from the SAS Enterprise Guide Open Stored Process GUI as seen below (note you can only
During the SAS Global Forum this past week, SAS offered several demos on mobile technology including: Michael Hecht, SAS, JMP iPad App Super Demo Chris Hemedinger hosted a Live Tech Talk on Tuesday that covered the new SAS Visual Analytics Explorer with demos on Microsoft Surface and iPad Apps Remember everyone is using mobile devices
This past Monday, Tricia and I released our 2nd book this year. "The 50 Keys to Learning SAS Stored Processes" provides a step-by-step approach to transitioning from SAS code into user driven (prompted) stored processes. Trimming down all the things you can do with SAS Stored Processes is next to
PROC STP is a new procedure for SAS 9.3 Stored Processes. It's so new and different that I have not had the opportunity to use it yet in a customer engagement. When writing about it for the now released "The 50 Keys to Learning SAS Stored Processes" book, I had
Functionality to upload files onto the SAS server (from 9.2 on) is available using stored processes and an html input type="file". I introduced this topic last year in my blog post using the SAS Stored Process Developer Guide sample. Of course, it is never as easy as the sample is
Every six months or so I try to find a recent picture that captures who I am and what I am feeling. Loading this into my various social/online profiles in Twitter, SAS Community, Forums, LinkedIn, corporate internal, Facebook etc then take me a bit of time to implement. Wouldn't it
It is definitely easier to force single selections for prompts used in SAS Stored Processes, however it isn't very usable when the majority of users need to select multiple values. For example, let us say we create a prompt for region (called 'region_prompt') and then use that in the query