Problem Note 10591: Calculated columns are created with the wrong data type
If you do not have any functions of type 'complex' defined in your
ISMCALCFUNCS control table in the SAS Campaign Management database, your
calculated columns may be created with the wrong type. For example, a
calculated column that is derived from a set of numeric values is
created as an alphanumeric instead of numeric field.
To workaround the problem, first insert a dummy function into
ISMCALCFUNCS (it must be of type 'complex'):
insert into ismcalcfuncs values('DUMMY()','DUMMY','DUMMY',
'Do not use this function- workaround','COMPLEX','CCFROMEXPRESSION')
After you add the dummy complex function, you must reload the affected
calculated columns. Enter and exit the Expression Builder window, then
repopulate the calculated column. The result type is then derived from
the first column in the expression.
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 | | | |
| Microsoft Windows XP Professional | 7.5 | | | |
| Microsoft Windows 2000 Professional | 7.5 | | | |
| Microsoft Windows 2000 Advanced Server | 7.5 | | | |
| Microsoft Windows 2000 Server | 7.5 | | | |
| Microsoft Windows 2000 Datacenter Server | 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: | high |
| Date Modified: | 2003-11-13 10:42:54 |
| Date Created: | 2003-08-07 15:04:52 |