BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ShenQicheng
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

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

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

View solution in original post

3 REPLIES 3
ChrisHemedinger
Community Manager

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

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
ShenQicheng
Obsidian | Level 7

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

ChrisHemedinger
Community Manager

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

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1218 views
  • 0 likes
  • 2 in conversation