Create stored process with SAS STUDIO

[kumarsandip975]

Hi,

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

Can somebody suggest. 

TIA.

[kumarsandip975]

We are using SAS STUDIO 3.81 Version.

[Cynthia_sas · Accepted solution]

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]

Thanks for detailed explanation. 🙂