SASDATEINFMT=

SASDATEINFMT=

Changes the SAS date informat of a data source column.

Default value: None

Option type: Data set only

Syntax
Details
Example: Using SASDATEINFMT to convert SAS dates into DBMS dates
See Also

Syntax

SASDATEINFMT=(date-column="SAS-date-format"...)

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

In this example, SAS changes the HIRED column from the default OLE DB data type to the DATE9. format before appending the data to the DBMS table.

proc append base=air.payroll
      data=mydblib.payroll2 
        (sasdateinfmt=(hired='DATE9.'));
run;

See Also

OLE DB Chapter, First Edition