topic Re: Autoexec in SAS Programming

Autoexec

sasjourney — Thu, 06 Mar 2014 15:42:20 GMT

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 — Thu, 06 Mar 2014 16:03:08 GMT

proc sql;

select setting into: autoexec

from dictionary.options

where optname='AUTOEXEC';

QUIT;

%PUT &AUTOEXEC;

Ron_MacroMaven — Thu, 06 Mar 2014 22:08:34 GMT

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