08-13-2012 04:44 PM
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?
Program name = Query123.sas
Macro variable to be created = Query123
Need further help from the community? Please ask a new question.