Autoexec

[sasjourney]

Hello Everyone,

Is there any way to create a macro variable with the name of the autoexec, which is being called by a program at run time.

Thanks

[ballardw · Accepted solution]

proc sql;

select setting into: autoexec

from dictionary.options

where optname='AUTOEXEC';

QUIT;

%PUT &AUTOEXEC;

[Ron_MacroMaven]

These statements do the same as ballarw.

%let filename=%sysfunc(getoption(autoexec));

%put filename:&filename;

I use a configuration file to set the value of autoexec; which shows as:

filename:!projects_root\SAS-site\autosite.sas

projects_root is an environment variable

Depending on how you start sas the option sas.initial.folder may have a path worth knowing

%put sasinitialfolder:%sysfunc(getoption(sasinitialfolder));

Ron Fehd  macro maven