topic Re: ODS Excel Filename with previous month date in ODS and Base Reporting

ODS Excel Filename with previous month date

SWard — Wed, 29 Apr 2020 16:37:48 GMT

I have a SAS program that creates an Excel file that includes the current date as part of the file name. The data in the file is from the prior month. How do I change the date to show the prior month in a MM-YYYY format?

Here is my current code that names the Excel file:

%let file1=/saswork/Corporate/Marketer_Services_Reporting/Data/_Scheduled Reports/CLASS Monthly/CLASS Completions-%QSYSFUNC(DATE(),worddate18.).xlsx;

ods excel file="&file1";

Re: ODS Excel Filename with previous month date

Reeza — Wed, 29 Apr 2020 17:08:57 GMT

%SYSFUNC(intnx(month, %sysfunc(DATE()), -1, e), mmyyd6.)

Re: ODS Excel Filename with previous month date

PaigeMiller — Wed, 29 Apr 2020 17:21:11 GMT

%let file1=/saswork/Corporate/Marketer_Services_Reporting/Data/_Scheduled Reports/CLASS Monthly/CLASS Completions-%sysfunc(today(),mmyyd7.).xlsx;

Although I think the formatting of MM-YYYY is a very poor choice because if you try to sort these files, they don't wind up in chronological order, they wind up with all the January files first regardless of year, and all the February files ...

Whereas yyyy-mm would always sort in chronological order.