Usage Note 8574: Using the SAS OLE DB provider to read a 16 digit number may round the
value
Using either the local or SAS/SHARE OLE DB provider to read a number
that contains 16 digits may round the value at 15 digits or display the
value incorrectly. This is because the provider stores the data as an
eight-byte, double precision, IEEE standard floating point value. This
data type is accurate to 15 decimal digits.
This display issue can be seen using the EG client to copy a SAS data
set (that contains a numeric greater than 2^52) from a server where the
option 'Automatically use OLE DB to access' is selected. Other
applications using either the local or the SAS OLE DB provider may show
this as well.
Operating System and Release Information
SAS System | Base SAS | Microsoft Windows XP Professional | 9 TS M0 | |
Microsoft Windows 2000 Advanced Server | 9 TS M0 | |
Microsoft Windows 2000 Datacenter Server | 9 TS M0 | |
Microsoft Windows 2000 Professional | 9 TS M0 | |
Microsoft Windows NT Workstation | 9 TS M0 | |
Microsoft Windows 2000 Server | 9 TS M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Date Modified: | 2006-07-25 16:39:28 |
Date Created: | 2002-10-02 13:29:08 |