BookmarkSubscribeRSS Feed
sathya66
Barite | Level 11

Is there a way that we can run stored procedure in Linux.please can you give me an example.

 

Thanks,

SAS

9 REPLIES 9
Kurt_Bremser
Super User

Of course. The whole SAS environment can be run on UNIX systems (which includes Linux). The only Windows-only software I know of is Enterprise Guide and the SAS Add-In for MS Office,

sathya66
Barite | Level 11
Have you got any example to run the stored procedure. I know we can run the sas code.
andreas_lds
Jade | Level 19

Just open the web-app, there are some demos included.

Sajid01
Meteorite | Level 14

@sathya66 
The following are two very simple examples for creating stored processes.
For a user the process is the same regardless of what OS (Windows/Linux) the server has.

https://video.sas.com/detail/video/3772834810001/create-a-stored-process-from-an-existing-sas-progra...

https://support.sas.com/resources/papers/proceedings13/148-2013.pdf

sathya66
Barite | Level 11
Sorry ,I want to run stored process from the linux box (Linux command line) just like sas code.
Kurt_Bremser
Super User

On the SAS server, you can start a SAS session in batch mode and run the stored process with PROC STP.

 

Or you use the saspy Python library, as described here.

 

And you can, of course, use any web tool (ie curl) to access the stored process web interface.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 9 replies
  • 984 views
  • 3 likes
  • 4 in conversation