topic How to export excel file ending with the date of export in SAS Programming

How to export excel file ending with the date of export

hhchenfx — Thu, 01 Jun 2017 22:48:06 GMT

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,

Re: How to export excel file ending with the date of export

Reeza — Thu, 01 Jun 2017 23:32:34 GMT

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;

Re: How to export excel file ending with the date of export

hhchenfx — Fri, 02 Jun 2017 00:23:04 GMT

Thanks a lot, Reeza.
HC