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.
Debugging a stored-process problem was published on SAS Users.
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.
Jobs: Stored processes in Viya was published on SAS Users.
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 non-distributed version of SAS Visual Analytics you may be particular …
This post appeared first on BI Notes for SAS Software Users. Go to the site to subscribe or view more content.
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Here’s a macro that can put distinct values of a variable in a SAS dataset to a macro variable of your choice.%macroput_distinct_varvalues_in_list(dsn,var,mac_var,dlm=comma,quotes=double); %global&mac_var.; …
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. I need a SAS stored process log.
If It Works for a Macro…
As a macro programmer …
Post Building a SAS Stored Process Log appeared first on BI Notes for SAS® Users. Go to BI Notes for SAS® Users to subscribe.
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 in here.” It was great because we watched him put …
Post SAS Stored Process Dealing with Disappearing Results appeared first on BI Notes for SAS® Users. Go to BI Notes for SAS® Users to subscribe.
Author: Quentin McMullen
I like most things SAS. But there are of course some features that I wish were implemented differently. One of those is selection list prompts. The good news is, even when SAS implements something in a way that I find, well let’s say, surprising, there is often a way to …
Post Taming SAS Stored Process Selection List Prompts appeared first on Business Intelligence Notes for SAS® BI Users. Written by Quentin McMullen. Go to Business Intelligence Notes for SAS® BI Users to subscribe.
Author: Quentin McMullen
a SAS programmer, I am dependent on my SAS autocall macro library. It stores a bunch of utility macros that I use on a daily basis. When I started learning about stored processes and other BI tools, one of my first thoughts was “How can I access all of my …
Post Using an Autocall Macro Library in SAS BI appeared first on Business Intelligence Notes for SAS® BI Users. Written by Quentin McMullen. Go to Business Intelligence Notes for SAS® BI Users to subscribe.