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
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.