topic Re: Call SAS directly from Perl script (Windows) in SAS Programming

Call SAS directly from Perl script (Windows)

Jim_Hayes — Mon, 09 Jun 2014 14:20:53 GMT

Greetings.

I want to call a SAS program directly from a perl script.

I have been able to call a .bat file which successfully runs the job, but would prefer to be able to execute the job directly from perl.

--Jim

Re: Call SAS directly from Perl script (Windows)

RW9 — Mon, 09 Jun 2014 14:34:18 GMT

Hi,

Not familiar with Perl, however if you can call a .bat file, then presumably you can access the command line via the same method. You would need to execute via command line something along the lines of

...\sas 9.2\sas.exe your_sas_script.sas

The SAS.EXE is the main executable which will open and compile the sas program.

Re: Call SAS directly from Perl script (Windows)

Jim_Hayes — Mon, 09 Jun 2014 15:48:38 GMT

That was my first attempt. but it failed.

--Jim

Re: Call SAS directly from Perl script (Windows)

SASKiwi — Tue, 10 Jun 2014 19:36:28 GMT

I suggest you test your SAS command first from a Windows command line. Once you have it working you can paste it into your Perl program. Also check out the SAS command documentation and try the -sysin option as well: ...\sas.exe -sysin mysasprog,sas.

Re: Call SAS directly from Perl script (Windows)

FriedEgg — Tue, 10 Jun 2014 20:14:39 GMT

With Windows, you can use the integration technologies client com interfaces to interact with a local sas installation (even if you do not license integration technologies). I may not be a necessary level of integration for you, especially given the presumption that you are a perl novice. To call SAS directly from perl use the system command:

system - perldoc.perl.org

@args = ("C:/path/to/sas.exe", "sysin C:/path/to/code.sas");
system(@args) == 0 or die "oops\n"