I am trying to write a macro that ends up creating a dataset and I want that dataset to be named whatever the name of the SAS code is that it is run on followed by _STATS. Basically I am trying to find out if there is a way to create a macro variable that's value is the name of the program currently being run. This will be part of an automated process so I need it to run without manual intervention. I was hoping there was an automatic macro variable that had this information but it does not appear to be the case. Is there a proc or something else that would allow the file name to be stored as a macro variable?
Example:
Program name = Query123.sas
Macro variable to be created = Query123
Thanks
It exists already:
%put %sysget(SAS_EXECFILENAME);
Perfect! Thanks!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.