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
proc sql;
select setting into: autoexec
from dictionary.options
where optname='AUTOEXEC';
QUIT;
%PUT &AUTOEXEC;
proc sql;
select setting into: autoexec
from dictionary.options
where optname='AUTOEXEC';
QUIT;
%PUT &AUTOEXEC;
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.