The following error might occur when using the SAS Report Portlet in the SAS^® Information Delivery Portal to display a SAS^® Web Report Studio report.

PROC SQL;
5        !          create view A1 as SELECT
6            ( table0.\date )  AS DIR_3 LABEL='Date' FORMAT=NLDATE20. ,
                      _
                      22
                      200
ERROR 22-322: Syntax error, expecting one of the following: a name, *.

This error is most likely to occur when the report uses an information map created from an SPD Server table, and the information map contains a reserved keyword for a variable name. For example, the word "date" is a reserved keyword.

To circumvent the problem, rename the variable so that it does not use a reserved keyword. For a list of reserved keywords, see (Reserved) Keywords.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Note: This issue does not occur in SAS Web Report Studio because the query optimizer compensates for the use of the reserved keyword. For information about the use of the query optimizer in SAS Information Delivery Portal, see SAS Note 51484.

Operating System and Release Information

A fix for this issue for SAS Web Report Studio 4.3 is available at:

A fix for this issue for SAS Web Report Viewer 4.3 is available at:

A fix for this issue for SAS AppDev Studio Eclipse Plug-ins 3.4_M2 is available at: