In SAS/AF, sometimes the last character of text included into the SCL preview buffer is truncated.
This behavior can also cause computed columns defined on a SAS/MDDB® cube to fail. The MDDB data model and corresponding SAS/EIS® OLAP client were developed as a proprietary SAS/AF application and use the SCL preview buffer to generate and compile computed column code.
For example, in the scenario reported, the computed column code had the last character truncated as it was being generated within the SCL preview buffer. The truncated character was a semicolon, which resulted in the compile error shown below. In the multidimensional report that was displaying, the computed column returned a value of zero for all rows instead of the correct computed values.
WARNING: A new catalog WORK._EISWK_ has been created.
127 end;
---
22
76
ERROR 22-322: Syntax error, expecting one of the following: !!, &, *, **, +, -,
'.', /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN,
NE, NOTIN, OR, ^=, |, ||, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
ERROR: Compile error(s) detected. No code generated.
ERROR: Compile error(s) detected. No code generated.
There is no circumvention for this issue.
Operating System and Release Information
SAS System | SAS/AF | z/OS | 9.1 TS1M0 | 9.3 TS1M1 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M0 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M0 | 9.3 TS1M1 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Server | 9.1 TS1M0 | |
Microsoft Windows 2000 Professional | 9.1 TS1M0 | |
Microsoft Windows NT Workstation | 9.1 TS1M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | 9.3 TS1M1 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | 9.3 TS1M1 |
Microsoft Windows XP Professional | 9.1 TS1M0 | 9.3 TS1M1 |
64-bit Enabled AIX | 9.1 TS1M0 | 9.3 TS1M1 |
64-bit Enabled HP-UX | 9.1 TS1M0 | 9.3 TS1M1 |
64-bit Enabled Solaris | 9.1 TS1M0 | 9.3 TS1M1 |
HP-UX IPF | 9.1 TS1M0 | 9.3 TS1M1 |
Linux | 9.1 TS1M0 | 9.3 TS1M1 |
OpenVMS Alpha | 9.1 TS1M0 | 9.3 TS1M1 |
Tru64 UNIX | 9.1 TS1M0 | 9.3 TS1M1 |
*
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.