How do I get SAS to write a timestamp to an exported file in a YYYYMMDDHHMMSS format?

[InspectahDex]

I have the following SAS code:

proc export data=work.dataset 

outfile="&ExportLoc./ABC_%sysfunc(today(),yymmdd10)_PROVIDER_TRIGGER.xlsx"    

dbms=xlsx replace;

 run;  

how do I get SAS to export out to a YYYYMMDDHHMMSS format in the filename instead?

[ketpt42]

With a picture format:

proc format;
    picture mytmefmt
        low-high = '%Y%0m%0d%0H%0M%0S'
        (datatype=datetime);
run;

%put %sysfunc(datetime(), mytmefmt.);

[smantha · Accepted solution]

proc export data=work.dataset 
outfile="&ExportLoc./ABC_%sysfunc(date(),yymmdd8.)%sysfunc(hour(%sysfunc(time())),z2.)%sysfunc(minute(%sysfunc(time())),z2.)%sysfunc(second(%sysfunc(time())),z2.)_PROVIDER_TRIGGER.xlsx"    
dbms=xlsx replace;
 run;  
​