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
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!
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.