• Print |
• E-mail  |
• Bookmark

When using SAS/ACCESS to Informix to query an Informix DECIMAL
floating point column, the display of the decimal portion of the number
from within SAS may be incorrect.   A DECIMAL floating point number in
Informix is a DECIMAL column that is declared without the scale
component.  The following 2 "create table" examples will create a
DECIMAL floating point column:
   create table example1 (c1 decimal(16))
   create table example2 (c2 decimal)
When these columns are extracted into the SAS System, the correct
numeric value is being pulled into SAS, the failure only happens on the
display of the number.  To circumvent the problem, an explicit format
needs to be applied to the column.  For example:

    data _null_;
       format c1 best;   /* explicit format applied */
      put c1=;
       run;

Operating System and Release Information