Convert SAS Dates to Excel Dates Via DEFINE Statement in Proc Report

[ijmoorejr]

I am using the following DEFINE statement with PROC REPORT in order to convert some SAS date values to Excel datetime values and then display the data in a m/d/yyyy format in Excel. The issue I'm having is that all of the date values are displaying as 1/1/1960. Please help with example DEFINE statements. Thanks.

define VAR1/ 'VAR1'  format=IS8601dt.   style(column)=[tagattr="type:Date format:m/d/yyyy"] center;

[Kurt_Bremser]

I can't find a IS8601DT format in the SAS documentation.

The E8601DT format is a datetime format and won't work with date values.