BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

Hi,

 

Is there any way we can create stored process with SAS Studio?

Can somebody suggest. 

 

TIA.

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
Diamond | Level 26

Hi:

  A SAS Stored Process is just a SAS program that has been modified to run using either the WORKSPACE server or the STORED PROCESS server in a BI Platform installation. Assuming you have code that needs to be modified, you could modify the code in any text editor, such as the editor in SAS Studio or any text editor such as Notepad or Wordpad. Deploying the stored process code, once modified, is the challenge. If you don't have code that can be modified, then a client application like Enterprise Guide has a Stored Process Wizard that can help turn your EG tasks and code snippets into stored process code. The finished stored process, on the BI Platform, must be registered in the Platform metadata so it can run from client applications, such as Enterprise Guide, Web Report Studio or the Stored Process Web Application (SPWA).

  SAS Studio does not have a stored process wizard like Enterprise Guide. Here is an older post related to SAS Studio 3.5 when someone asked about stored process creation and SAS Studio: https://communities.sas.com/t5/SAS-Studio/Creating-stored-process-in-SAS-Studio-3-5/td-p/299961

  One of the things about SAS Studio is that it is frequently used in a SAS Viya installation and while SAS Viya does have a concept similar to a stored process, if you are running in a Viya environment instead of a BI Platform environment, then you may want to investigate SAS Studio flows and SAS Studio jobs that are specifically designed to work with SAS Viya servers. Here is a Communities article on the topic of SAS Viya jobs: https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-jobs-object-model-explained/ta-p/633... .

 

  Hope this helps explain the difference,

Cynthia

View solution in original post

3 REPLIES 3
kumarsandip975
Pyrite | Level 9
We are using SAS STUDIO 3.81 Version.
Cynthia_sas
Diamond | Level 26

Hi:

  A SAS Stored Process is just a SAS program that has been modified to run using either the WORKSPACE server or the STORED PROCESS server in a BI Platform installation. Assuming you have code that needs to be modified, you could modify the code in any text editor, such as the editor in SAS Studio or any text editor such as Notepad or Wordpad. Deploying the stored process code, once modified, is the challenge. If you don't have code that can be modified, then a client application like Enterprise Guide has a Stored Process Wizard that can help turn your EG tasks and code snippets into stored process code. The finished stored process, on the BI Platform, must be registered in the Platform metadata so it can run from client applications, such as Enterprise Guide, Web Report Studio or the Stored Process Web Application (SPWA).

  SAS Studio does not have a stored process wizard like Enterprise Guide. Here is an older post related to SAS Studio 3.5 when someone asked about stored process creation and SAS Studio: https://communities.sas.com/t5/SAS-Studio/Creating-stored-process-in-SAS-Studio-3-5/td-p/299961

  One of the things about SAS Studio is that it is frequently used in a SAS Viya installation and while SAS Viya does have a concept similar to a stored process, if you are running in a Viya environment instead of a BI Platform environment, then you may want to investigate SAS Studio flows and SAS Studio jobs that are specifically designed to work with SAS Viya servers. Here is a Communities article on the topic of SAS Viya jobs: https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-jobs-object-model-explained/ta-p/633... .

 

  Hope this helps explain the difference,

Cynthia

kumarsandip975
Pyrite | Level 9
Thanks for detailed explanation. 🙂

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Develop Code with SAS Studio

Get started using SAS Studio to write, run and debug your SAS programs.

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
  • 1563 views
  • 0 likes
  • 2 in conversation