topic Re: How to execute a sas macro under a unix server in SAS Enterprise Guide

How to execute a sas macro under a unix server

alepage — Wed, 09 Dec 2020 22:08:51 GMT

Hello,

I would like to know how to call a macro on a Unix server (see the macro below)

%macro Transferbookibnrtodev(dev=,cie=,yyyy=,mm=);

libname source spde "/dwh_actuariat/sasdata/sas2020/&cie.";
libname dest spde "/dwh_actuariat/sasdata/sas2020&dev./&cie.";

proc copy in=source out=dest;

select &cie._bookibnr_&yyyy.&mm.;

If we need to make a ksh file , please provide an example

Regards,

run;

libname source clear;
libname dest clear;

/*Example of call: %Transferbookibnrtodev(dev=5,cie=golf ,yyyy=2020,mm=10);*/

%mend Transferbookibnrtodev;

Re: How to execute a sas macro under a unix server

SASKiwi — Wed, 09 Dec 2020 22:18:28 GMT

SAS macros run the same way regardless of operating system.

You define the macro first then call it:

%macro MyMacro;

< statements>

%mend MyMacro;

%MyMacro;

Re: How to execute a sas macro under a unix server

Tom — Wed, 09 Dec 2020 22:26:03 GMT

Not sure why you need a shell script. To run a program from the command line first save the SAS code into a file. It is normal to use .sas as the extension on the file. Then from the command prompt you type the command sas (or whatever command your systems team created to run sas) followed by the name of the file. If you don't include the .sas extension SAS will add it.

sas myprogram

The result will be a file named myprogram.log and possible a file named myprogram.lst written in the current directory.