topic Re: Can we run a SAS stored procedures in Linux in Administration and Deployment

Can we run a SAS stored procedures in Linux

sathya66 — Mon, 25 Jul 2022 09:31:03 GMT

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

Thanks,

SAS

Re: Can we run a SAS stored procedures in Linux

andreas_lds — Mon, 25 Jul 2022 09:17:21 GMT

Why not?

Re: Can we run a SAS stored procedures in Linux

Kurt_Bremser — Mon, 25 Jul 2022 09:29:04 GMT

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,

Re: Can we run a SAS stored procedures in Linux

sathya66 — Mon, 25 Jul 2022 09:33:17 GMT

Have you got any example to run the stored procedure. I know we can run the sas code.

Re: Can we run a SAS stored procedures in Linux

andreas_lds — Mon, 25 Jul 2022 10:14:03 GMT

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

Re: Can we run a SAS stored procedures in Linux

Kurt_Bremser — Mon, 25 Jul 2022 13:33:38 GMT

How do you run your SAS codes? Through Enterprise Guide, SAS Studio or the native Display Manager?

Re: Can we run a SAS stored procedures in Linux

Kurt_Bremser — Mon, 25 Jul 2022 13:36:14 GMT

And take a look at this:

SAS® 9.4 Stored Processes: Developer’s Guide

Re: Can we run a SAS stored procedures in Linux

Sajid01 — Mon, 25 Jul 2022 21:27:24 GMT

@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-program

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

Re: Can we run a SAS stored procedures in Linux

sathya66 — Wed, 03 Aug 2022 10:48:30 GMT

Sorry ,I want to run stored process from the linux box (Linux command line) just like sas code.

Re: Can we run a SAS stored procedures in Linux

Kurt_Bremser — Wed, 03 Aug 2022 12:00:10 GMT

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.