storage of macro

[deleted_user]

How to store macro and how to call the macro?

[deleted_user]

From SAS documentation:

MAUTOSOURCE System Option

--------------------------------------------------------------------------------

Controls whether the autocall feature is available Type: System option
Valid in: Configuration file

OPTIONS window
OPTIONS statement
SAS invocation


Default: MAUTOSOURCE
PROC OPTIONS GROUP= MACRO

MAUTOSOURCE | NOMAUTOSOURCE

MAUTOSOURCE
causes the macro processor to search the autocall libraries for a member with the requested name when a macro name is not found in the WORK library.

===========================================================

SASAUTOS= System Option

--------------------------------------------------------------------------------

Specifies one or more autocall libraries Type: System option
Valid in: Configuration file

OPTIONS window
OPTIONS statement
SAS invocation

PROC OPTIONS GROUP= ENVFILES
MACRO

SASAUTOS= library-specification |
(library-specification-1 . . . , library-specification-n)

Details


When SAS searches for an autocall macro definition, it opens and searches each location in the same order that it is specified in the SASAUTOS option. If SAS cannot open any specified location, it generates a warning message and sets the NOMAUTOSOURCE system option on. To use the autocall facility again in the same SAS session, you must specify the MAUTOSOURCE option again.

===========================================================

We created a directory which we call "MACLIB".
The directory exists in Prod, Test and Dev -- .../Prod/MacLib, .../Test/MacLib, .../Dev/MacLib.
We have a standard library that we define:
Libname maclib (".../&environment/MacLib", ".../Prod/MacLIb") ;
We then define the options:
options MAUTOSOURCE SASAUTOS=(MacLib, SASAUTOS);

"&environment" is set earlier by a macro that recognizes where the source code is being executed from so that it can set the runtime environment: Prod, Test or Dev.
This method allows for change control, and means you don't have to have a complete copy of production in the development and test environments.

Read about concatenated Libraries in the SAS documentation.