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

ijmoorejr — Tue, 19 Feb 2019 01:44:53 GMT

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;

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

Kurt_Bremser — Tue, 19 Feb 2019 06:02:15 GMT

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.

topic Re: Convert SAS Dates to Excel Dates Via DEFINE Statement in Proc Report in ODS and Base Reporting

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

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