Data Set Options for Relational Databases SASDATEFMT= Data Set Option 209
increase performance. However, because SAS stores the rows in memory, higher values
for READBUFF= use more memory. In addition, if too many rows are selected at once,
then the rows that are returned to the SAS application might be out of date.
When READBUFF=1, only one row is retrieved at a time. The higher the value for
READBUFF=, the more rows that the SAS/ACCESS engine retrieves in one fetch
operation.
DB2 UNIX/PC Details: By default, the SQLFetch API call is used and no internal
SAS buffering is performed. Setting READBUFF=1 or greater causes the
SQLExtendedFetch API call to be used. ROWSET_SIZE is an alias for this option.
ODBC and SQL Server Details: By default, the SQLFetch API call is used and no
internal SAS buffering is performed. Setting READBUFF=1 or greater causes the
SQLExtendedFetch API call to be used. ROWSET_SIZE is an alias for this option.
OLE DB Details: ROWSET_SIZE is an alias for this option.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “READBUFF= LIBNAME Option” on page 121.
SASDATEFMT= Data Set Option
Changes the SAS date format of a DBMS column
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle, Microsoft SQL Server,
SYBASE, Teradata
Default value:
DBMS-specific
Syntax
SASDATEFMT=(<DBMS-date-col-1=’SAS-date-format’>
<... <DBMS-date-col-n=’SAS-date-format’>>)
Syntax Description
DBMS-date-col
specifies the name of a date column in a DBMS table.
SAS-date-format
specifies a SAS date format that has an equivalent (like-named) informat. For
example, DATETIME21.2 is both a SAS format and a SAS informat, so it is a valid
value for the SAS-date-format argument.
Details
If the date format of a SAS column does not match the date format of the corresponding
DBMS column, you must convert the SAS date values to the appropriate DBMS date
values. The SASDATEFMT= option enables you to convert date values from the default
SAS date format to another SAS date format that you specify.
