%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.
... View more
