A stored compiled macro library can be created using the MSTORED and SASMSTORE system options along with the STORE option on the %MACRO statement. MSTORED simply enables the use of stored compiled macros, where SASMSTORE= specifies the libref that references the SAS library where the catalog of stored compiled macros is stored or will be stored. The STORE option on the %MACRO statement stores the compiled macro as an entry in a SAS catalog SASMACR in the library referenced by the SASMSTORE= system option.

   /* the libref MYMACS points to the SAS library where the
   stored compiled macro is to be stored */

   LIBNAME MYMACS ‘C:\MACROS’;
   OPTIONS MSTORED SASMSTORE=MYMACS;
   %MACRO TEST / STORE;
      code;
   %MEND;

The above code will compile the macro TEST and store it in a catalog called SASMACR in the SAS library MYMACS. The following syntax can be used to invoke the macro in a subsequent SAS session.

   LIBNAME MYMACS ‘C:\MACROS’;

   OPTIONS MSTORED SASMSTORE=MYMACS;

   %TEST

Important: It is important to know that once a macro has been compiled, there is no way to retrieve the code. It is recommended that the SOURCE option be used along with the STORE option to ensure the code is not lost. See the following link for more information on the SOURCE option.

Click here to go to SAS Note 22352

The link below will take you to the %MACRO statement.

Click here to read about the %MACRO statement

Operating System and Release Information