Problem Note 10439: Calculated columns may lose precision
Within the SAS Campaign Management component, if you set up a calculated
column as a decimal and you specify a decimal width that is not valid
given the total field width, you will receive no error or warning.
Instead, the decimal width may be truncated, thus limiting the precision
of the values stored in the calculated column. For example, if you
enter a field definition of 12.11 (total field width of 12, decimal
width of 11), the column is actually created with a format of 12.1 and
you are given no notification of this change.
To workaround the problem, be sure that the width you specify for the
decimal portion of the value is small enough to fit within the total
width of the variable. For example, if you define the total width to
be 12, the decimal width can be no larger than 10 digits (allowing one
position for the decimal point itself, and one position for the leading
digit preceding the decimal point).
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.4 | 7.5 | | |
| Microsoft Windows XP Professional | 7.4 | 7.5 | | |
| Microsoft Windows 2000 Professional | 7.4 | 7.5 | | |
| Microsoft Windows 2000 Advanced Server | 7.4 | 7.5 | | |
| Microsoft Windows 2000 Server | 7.4 | 7.5 | | |
| Microsoft Windows 2000 Datacenter Server | 7.4 | 7.5 | | |
*
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.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2003-08-04 15:24:34 |
| Date Created: | 2003-07-17 14:46:05 |
