DATA Step, Macro, Functions and more

PROC EXPORT to Excel with dynamic name

Reply
N/A
Posts: 0

PROC EXPORT to Excel with dynamic name

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.
N/A
Posts: 0

Re: PROC EXPORT to Excel with dynamic name

Posted in reply to deleted_user
Never mind all. This thread took care of my question:

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

Thanx.
Ask a Question
Discussion stats
  • 1 reply
  • 226 views
  • 0 likes
  • 1 in conversation