Select Your Region
Americas
Europe
Middle East & Africa
Asia Pacific
SUPPORT / SAMPLES & SAS NOTES
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | ||||