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

A fix for this issue for Base SAS 9.21_M3 is available at:

A fix for this issue for Base SAS 9.3 is available at: