Problem Note 10905: Data type error occurs when creating a calculated column
If you attempt to create a calculated column using the DECILE function
in the SAS Campaign Management component, you may receive an error
similar to the following:
S1000: [SAS][SAS ODBC Driver][SAS Server]ERROR: Value 4 on the SELECT
clause does not match the data type of the corresponding column
This problem occurs when the data referenced in the calculated column
expression comes from a table with an alphanumeric key. Currently, the
DECILE function requires the table being processed to possess a numeric
key.
A Technical Support hot fix for this issue is available at:
http://ftp.sas.com/techsup/download/hotfix/cam75.html
Operating System and Release Information
| SAS System | SAS Campaign Management | Microsoft Windows NT Workstation | 7.5 | 4.0 | | |
| Microsoft Windows XP Professional | 7.5 | 4.0 | | |
| Microsoft Windows 2000 Professional | 7.5 | 4.0 | | |
| Microsoft Windows 2000 Advanced Server | 7.5 | 4.0 | | |
| Microsoft Windows 2000 Server | 7.5 | 4.0 | | |
| Microsoft Windows 2000 Datacenter Server | 7.5 | 4.0 | | |
*
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-11-13 11:24:50 |
| Date Created: | 2003-09-23 16:45:26 |
