Problem Note 54696: The error "Invalid Expression" occurs when you create a calculated variable in an expression that includes multiple variable names that are similar
 |  |  |  |  |
You can create calculated variables for use in nodes within SAS® Real-Time Decision Manager decision campaigns.
When you define an expression in the Calculated Variables Properties window, you can define multiple variables in that expression, as shown in the following example:
COALESCEC(<<Global Variables.FIRSTNAME>>,<<Global Variables.SECONDNAME>>)
However, if the variable names are similar, you might see the following error when you click either the OK button or the Validate button in the Calculated Variables Properties window:
As shown in the following example, the problem occurs when the second variable name contains the same initial characters as in the first variable name. (Note that this does not include the system-generated part of the names.)
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Real-Time Decision Manager | Solaris for x64 | 5.41 | 6.3 | 9.3 TS1M2 | 9.4 TS1M1 |
| Linux for x64 | 5.41 | 6.3 | 9.3 TS1M2 | 9.4 TS1M1 | ||
| HP-UX IPF | 5.41 | 6.3 | 9.3 TS1M2 | 9.4 TS1M1 | ||
| 64-bit Enabled Solaris | 5.41 | 6.3 | 9.3 TS1M2 | 9.4 TS1M1 | ||
| 64-bit Enabled AIX | 5.41 | 6.3 | 9.3 TS1M2 | 9.4 TS1M1 | ||
| Microsoft® Windows® for x64 | 5.41 | 6.3 | 9.3 TS1M2 | 9.4 TS1M1 | ||