Hi All,
I have created the Stored process by including some Prompts in SAS Management console and set the options of the servers as shown in below first screen and when I try to execute it in SAS WRS then I getting error shown in the second screen.
Can anyone help me how can I get rid of this error? Much appriciate your help!!
Been quite awhile since I worked with WRS, so I could be out of bounds here.
But WRS i default executing on a pooled WS server. So I would start with to change the server option to "Default".
Another thing to look at is metadata authorization.
The most likely reason why the stored process fails is that you do not have Package output selected. SAS Web Report Studio does not support Streaming stored processes.
I also recommend that you review this SAS note:
http://support.sas.com/kb/47/839.html
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.