Hi there, The thread below suggests that the issue of datetime values formatted as General when using ODS Excel would be addressed in the M3 patch. However, I'm encountering the issue on a server patched to M4, so is it still a problem? EDIT: Server version: 9.04.01M4P110916 https://communities.sas.com/t5/ODS-and-Base-Reporting/Write-DATETIME-values-to-ODS-EXCEL/m-p/205533/highlight/true#M13639 My code: proc format lib=work;
picture dtspec
. = ' '
other='%0d/%0m/%Y %0H:%0M:%0S' (datatype=datetime );
;
run;
data date_test(keep=testdate);
format testdate dtspec.;
testdate='01JAN2018 08:36:09'dt;
run;
ods listing close;
ods excel file="/<path>/testdates.xlsx";
proc report data = date_test;
title j=l "Test";
column testdate;
define testdate / style(column)={tagattr='format:dd/mm/yy;@'} group left;
run;
ods excel close;
ods listing; Much like the OP above, editing the cell with F2 and pressing enter forces the format to resolve, but it initially displays as General. Any suggestions at all would be welcome. I'd like to use ODS Excel over ExcelXP purely for its native support of the XLSX file type (removes the need for a conversion script after each ODS step)/ Thanks in advance.
... View more