PROC EXPORT to Excel with dynamic name

[deleted_user]

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.

Thanx.

[deleted_user]

Never mind all. This thread took care of my question:

http://support.sas.com/forums/thread.jspa?messageID=9695◟

Thanx.