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

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

InspectahDex — Tue, 07 Jul 2020 20:01:41 GMT

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?

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

ketpt42 — Tue, 07 Jul 2020 20:43:29 GMT

With a picture format:

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

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

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

smantha — Tue, 07 Jul 2020 20:50:19 GMT

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;