Maintaing date format when exporting to XLSX

[tomcmacdonald]

How do I maintain date formats in Excel when using PROC EXPORT?  I have tried ODS Excel but need to maintain the default Excel styling and not use any SAS styling. 

[Reeza · Accepted solution]

If I export a data set with SAS date9 format it seems to be fine using DMBS=XLSX

Or use ODS EXCEL and chose style=minimal to have little SAS formatting. You could also make your own style that had minimal to no changes.

proc export data=sashelp.stocks outfile='C:\_localdata\temp\test1.xlsx' dbms=xlsx replace; run;

ods excel file='C:\_localdata\temp\test2.xlsx' style=journal2;

proc print data=sashelp.stocks;
run;

ods excel close;