issues a warning in the SAS log if the BIGINT data type is in a DBMS table.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Alias: | BIGINT_WARN= |
| Default: | NO |
| Data source: | DB2 under UNIX and PC Hosts, Microsoft SQL Server |
Table of Contents
issues a warning in the SAS log if a BIGINT data type is in a DBMS table.
specifies that the warning for a BIGINT data type does not appear in the SAS log.
If a BIGINT data type is detected in the result set and if WARN_BIGINT=YES, the log contains this warning:
A column of type BIGINT was detected in the result set. As BIGINT values are stored in SAS as DOUBLE PRECISION values, you may receive inexact results if the BIGINT value has a precision greater than 15 digits. Consider using the DBSASTYPE option to convert the BIGINT column into character value to preserve the precision of the BIGINT value.