Problem Note 54599: A syntax error might occur when you run a procedure against a SAS® Information Map that references negative numbers
When you run a procedure against a SAS Information Map, you might see errors that are similar to the following:
Error while submitting SAS code
17 ( case when table1.Age in (-1, 11, 12, 14, 15, 16) then 999 else 13 end ) IN ( (-1),
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: (, SELECT.
ERROR 76-322: Syntax error, statement will be ignored.
This error occurs if the information map includes an expression that references negative numbers in an IN clause. For example, if you insert a data item with the following expression into the information map, the error occurs when you attempt to run a procedure against the information map.
insert dataitem
name = 'Student Age'
expression = 'case when <> in (-1, 11, 12, 14, 15, 16) then 999 else 13 end'
type = character
id = 'age';
To resolve this issue, add the following option to the JREOPTIONS section of your sasv9.cfg
file. You must be running SAS® 9.4_M2 or later to use the option.
-DSASQueryServices.BiqNoNegParens=Y
Operating System and Release Information
SAS System | Base SAS | Aster Data nCluster on Linux x64 | 9.3 TS1M0 | 9.4 TS1M2 |
DB2 Universal Database on AIX | 9.3 TS1M0 | 9.4 TS1M2 |
DB2 Universal Database on Linux x64 | 9.3 TS1M0 | 9.4 TS1M2 |
Greenplum on Linux x64 | 9.3 TS1M0 | 9.4 TS1M2 |
Netezza TwinFin 32bit blade | 9.3 TS1M0 | 9.4 TS1M2 |
Netezza TwinFin 32-bit SMP Hosts | 9.3 TS1M0 | 9.4 TS1M2 |
Netezza TwinFin 64-bit S-Blades | 9.3 TS1M0 | 9.4 TS1M2 |
Netezza TwinFin 64-bit SMP Hosts | 9.3 TS1M0 | 9.4 TS1M2 |
Teradata on Linux | 9.3 TS1M0 | 9.4 TS1M2 |
z/OS | 9.3 TS1M0 | 9.4 TS1M2 |
Z64 | 9.3 TS1M0 | 9.4 TS1M2 |
Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.4 TS1M2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | |
Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | |
Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | |
Microsoft Windows Server 2008 | 9.3 TS1M0 | 9.4 TS1M2 |
Microsoft Windows Server 2008 R2 | 9.3 TS1M0 | 9.4 TS1M2 |
Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | 9.4 TS1M2 |
Microsoft Windows XP Professional | 9.3 TS1M0 | |
Windows 7 Enterprise 32 bit | 9.3 TS1M0 | 9.4 TS1M2 |
Windows 7 Enterprise x64 | 9.3 TS1M0 | 9.4 TS1M2 |
Windows 7 Home Premium 32 bit | 9.3 TS1M0 | 9.4 TS1M2 |
Windows 7 Home Premium x64 | 9.3 TS1M0 | 9.4 TS1M2 |
Windows 7 Professional 32 bit | 9.3 TS1M0 | 9.4 TS1M2 |
Windows 7 Professional x64 | 9.3 TS1M0 | 9.4 TS1M2 |
Windows 7 Ultimate 32 bit | 9.3 TS1M0 | 9.4 TS1M2 |
Windows 7 Ultimate x64 | 9.3 TS1M0 | 9.4 TS1M2 |
Windows Vista | 9.3 TS1M0 | |
Windows Vista for x64 | 9.3 TS1M0 | |
64-bit Enabled AIX | 9.3 TS1M0 | 9.4 TS1M2 |
64-bit Enabled HP-UX | 9.3 TS1M0 | 9.4 TS1M2 |
64-bit Enabled Solaris | 9.3 TS1M0 | 9.4 TS1M2 |
HP-UX IPF | 9.3 TS1M0 | 9.4 TS1M2 |
Linux | 9.3 TS1M0 | 9.4 TS1M2 |
Linux for x64 | 9.3 TS1M0 | 9.4 TS1M2 |
Solaris for x64 | 9.3 TS1M0 | 9.4 TS1M2 |
*
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: | 2014-11-12 10:11:21 |
Date Created: | 2014-11-11 14:26:25 |