126 STRINGDATES= LIBNAME Option Chapter 9
STRINGDATES= LIBNAME Option
Specifies whether to read date and time values from the database as character strings or as
numeric date values
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support:
DB2 UNIX/PC, ODBC, OLE DB, Microsoft SQL Server
Default value:
NO
Syntax
STRINGDATES= YES | NO
Syntax Description
YES
specifies that SAS reads date-time values as character strings.
NO
specifies that SAS reads date-time values as numeric date values.
Details
STRINGDATES=NO is used for Version 6 compatibility.
SQL_FUNCTIONS= LIBNAME Option
Specifies that the functions that match those supported by SAS should be passed to the DBMS
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
DB2 UNIX/PC, ODBC, OLE DB
Default value: NONE
Syntax
SQL_FUNCTIONS=ALL
Syntax Description
ALL
specifies that functions that match those that are supported by SAS should be passed
to the DBMS.
