I create a stored process from a program with following code:
data _null_;
set sashelp.cars;
run;
and set the server type to 'Workspace Server only' in execution option.
When I run the stored process, 'server type' in task status pane always shows 'Stored Process' but not 'Workspace' which I expect.
So what does this 'server type' exactly means?
Shen
Shen,
Yes, I'll bet that's correct. Even if the Stored Process is running on a the Workspace Server instance, it wouldn't surprise me if the status shows "Stored Process" since that's the method being used...
Chris
This Server Type field provides you (the end user) with an idea of what type of SAS session is running your job. The Workspace server is most common for typical connections, but as you noted the Stored Process server can be used for SAS stored processes. Also, customers with a SAS Grid Computing environment might see "Grid" when their SAS jobs are running on a distributed grid node.
Chris
Thanks, Chris
That means, the Server Type field will always show stored process even if the excution option of the stored process was set to Workspace Server Only? (In an environment other than Grid Computing)
Shen
Shen,
Yes, I'll bet that's correct. Even if the Stored Process is running on a the Workspace Server instance, it wouldn't surprise me if the status shows "Stored Process" since that's the method being used...
Chris
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.