How do I get the date format changed to mmddyyyy in the proc export step

[panopolix]

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.

[Reeza]

Change the format in the CALL SYMPUT() to what you want it. Here you've specified date9, but I would recommend using yyyy.mm.dd which will sort correctly using ascending or descending.

call symputx('datenow', put(date()-1, yymmddp10.));

I also recommend changing to SYMPUTX which trims any extra spaces.

You also need to remove the single quotes in your outfile statement.

outfile="\\SharedFolder\REPORT_&datenow..xlsx"

[panopolix · Accepted solution]

Thank you Reeza! That works.