data_null_; call symput ('datenow', put((date()-1), date9.)); run; proc export data=mydata; outfile="\\SharedFolder\REPORT_&'datenow'..xlsx" dbms=xlsx replace; run; When I run this code, I am getting the date on the spreadsheet as REPORT_26MAR2020.xlsx Would it be possible to get it in this format: REPORT_03.26.2020.xlsx Thank you.
... View more
