topic Re: How to store SAS Macros in a permanent Library in Developers

How to store SAS Macros in a permanent Library

Rakesh93 — Thu, 10 Oct 2019 13:32:31 GMT

How to store SAS Macros in a permanent Library?

eg:

%macro import(set,sh,op);
proc import datafile="D:\SAS Docs\CDM Docs\Protocol.xlsx" dbms=xlsx out=&set replace;
sheet=&sh;
getnames=&op;
run;
proc print data=&set;run;
%mend;

This is a macro but it is getting stored in Work Library. I want to store it in a permanent Library. How?

Re: How to store SAS Macros in a permanent Library

Kurt_Bremser — Thu, 10 Oct 2019 13:41:16 GMT

Store the macro as code in your autocall library.

Re: How to store SAS Macros in a permanent Library

Tom — Thu, 10 Oct 2019 13:46:03 GMT

It is possible to store COMPILED macros into catalogs and tell SAS to look for them there.

But it is much easier to create and manage if you use the SASAUTOS facility instead. Use the SASAUTOS option to point to a folder (or series of folders) where SAS can look for an auto-compile the macro from the source. Place each macro in its own individual file. Name the file with the name of the macro with .sas extension. Make sure to use lowercase letters for the filename. So your example should be stored in a file named import.sas.

Re: How to store SAS Macros in a permanent Library

Rakesh93 — Thu, 10 Oct 2019 16:20:32 GMT

Can you explain with an example?

Re: How to store SAS Macros in a permanent Library

Kurt_Bremser — Thu, 10 Oct 2019 16:36:30 GMT

Read the documentation that I linked in my previous post. If you have specific questions, ask them.

Re: How to store SAS Macros in a permanent Library

Rakesh93 — Fri, 11 Oct 2019 06:24:52 GMT

Please explain the Syntax of Sasautos in SAS environment.

Re: How to store SAS Macros in a permanent Library

Kurt_Bremser — Fri, 11 Oct 2019 06:38:23 GMT

@Rakesh93 wrote:

Please explain the Syntax of Sasautos in SAS environment.

SASAUTOS System Option

Re: How to store SAS Macros in a permanent Library

Tom — Fri, 11 Oct 2019 11:58:28 GMT

Make a directory on you filesystem. For example

/home/me/sas_macros/

Make a macro and store it in a file in that directory. For example a macro name %MyMac() might be in a file named.

/home/me/sas_macros/mymac.sas

And have content like:

%macro MyMac(dsname);
proc contents data=&dsname;
run;
%mend MyMac;

Then in your main program add this line to tell SAS where to find the macros:

options insert=(sasautos=('/home/me/sas_macro'));

And then after than in your main program you just call the macro.

%mymac(sashelp.class)

If you have called it before it just runs, but if not then SAS will search the folders in the SASAUTOS option tor the file named 'mymac.sas' and include it. Then, now that the macro has been compiled, it calls it.

Re: How to store SAS Macros in a permanent Library

Rakesh93 — Mon, 14 Oct 2019 04:38:32 GMT

While running this file:

%MyMac(dsname);
proc contents data=&dsname;
run;
%mend MyMac;

It shows no matching macro with mend.

Re: How to store SAS Macros in a permanent Library

Tom — Mon, 14 Oct 2019 05:11:32 GMT

You are missing the keyword MACRO in the first line.
%macro MyMac(dsname);