How to export excel file ending with the date of export

[hhchenfx]

Hi Everyone,

I want to export my data to excel and the name of the excel file end with _mmddyy_hourminute of the date I export.

Could any help me please?

Thanks,

HC

[Reeza · Accepted solution]

You need to figure out the exact format that will work for you but the idea is as follows:

proc export ....  outfile = " path to file _ %sysfunc(today(), yymmdd8.)_%sysfunc(time(), time8.).xlsx"

The follow helps for testing your formats. I would highly recommend a YYMMDD format for the date then it will at least sort correctly by default which it won't otherwise. 

%let date = %sysfunc(today(), yymmdd8.);
%let now = %sysfunc(time(), time8.);

%put &date _ &now;

[hhchenfx]

Thanks a lot, Reeza.
HC