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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.