Maintaing date format when exporting to XLSX

tomcmacdonald — Wed, 20 Dec 2017 15:53:06 GMT

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.

Re: Maintaing date format when exporting to XLSX

Reeza — Wed, 20 Dec 2017 16:27:22 GMT

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;

topic Maintaing date format when exporting to XLSX in SAS Programming

Maintaing date format when exporting to XLSX

Re: Maintaing date format when exporting to XLSX