I have a data set that is named dynamically but simply data_&now (where &now refers to today's date 10FEB2009). I need to export the data to an Excel file with the same name. I'm pretty new to SAS and have only seen thus far where a hard coded name to a particular location can be used like OUTFILE = C:\AW\newdata.xls'.
Is there a way that I can export to an Excel spreadsheet and keep the naming convention of the data set without having to change the file name manually in the OUTFILE parameter?
So I would want the Excel name to be data_10FEB2009 today and data_11FEB2009 tomorrow and so on, without having to manually change anything.