SASDATEFMT=

SASDATEFMT=

Changes the SAS date format of a DBMS column

Default value: None

Syntax
Details
Example: Using SASDATEFMT to convert a date column to a SAS date format

Syntax

SASDATEFMT=(DBMS-date-col="SAS-date-format" ...)

For a full description of this option, refer to SASDATEFMT= .

In this example, SAS changes the format of the HIRED column to the SAS DATE9. format for reading the data in SAS.

proc print data=mydblib.payroll
   (sasdatefmt=(hired='DATE9.'));
run;