Problem Note 37133: SAS® Anti-Money Laundering macro ROUTE.SAS might generate an error when the advanced routing rule contains IN or NOT IN operators on multiple values
 |  |  |  |
The ROUTE.SAS macro might generate an error if the advanced routing rule contains an IN or NOT IN operators on multiple values. Advanced routing rules are defined in the Scenario Administrator to route alerts to users based on defined conditions.
Below is an example of the errors that might appear in the log. An IN operator is used to search SCENARIO_NAME for multiple scenario names. The problem occurs when the code generator does not assign parentheses around these values.
ERROR 79-322: Expecting a (.
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a
numeric constant, a datetime constant, a missing value, iterator, (, ), ','.
ERROR 76-322: Syntax error, statement will be ignored.
ERROR 161-185: No matching DO/SELECT statement.
The ROUTE code generator now adds parentheses when multiple values are specified.
*
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.
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a
numeric constant, a datetime constant, a missing value, iterator, (, ), ','.
ERROR 76-322: Syntax error, statement will be ignored.
ERROR 161-185: No matching DO/SELECT statement.
The ROUTE code generator now adds parentheses when multiple values are specified.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Linux | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M3 |
| 64-bit Enabled Solaris | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Windows Vista | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2008 | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Advanced Server | 2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
The ROUTE.SAS macro might generate an error if the advanced routing rule contains an IN or NOT IN operator for multiple values. Advanced routing rules are defined in the Scenario Administrator to route alerts to users based on defined conditions.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-12-21 15:13:48 |
| Date Created: | 2009-09-09 15:20:51 |