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
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.