SAS Studio

Write and run SAS programs in your web browser
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
SAS Super FREQ

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
SAS Super FREQ

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-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

SAS Training: Just a Click Away

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

Browse our catalog!

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