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"; ... View more