topic Re: How do I get the date format changed to mmddyyyy in the proc export step in New SAS User

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

panopolix — Fri, 27 Mar 2020 18:18:01 GMT

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.

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

Reeza — Fri, 27 Mar 2020 18:28:11 GMT

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"

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

panopolix — Fri, 27 Mar 2020 18:40:45 GMT

Thank you Reeza! That works.