In SAS Enterprise Guide 5.1, when running in explicit pass-through mode, the Query Builder generates SQL code that encloses alias and column names in double quotation marks.

In most cases, such as working with ORACLE and NETEZZA databases, the addition of the quotation marks generates a syntax error.

In addition, when joining only two tables, the table and column names are not quoted in the INNER JOIN statement, which leads to an error similar to the following.

ERROR: ORACLE prepare error: ORA-00904: "T2"."NAME": invalid identifier. SQL statement: SELECT 
       "t1"."NAME", "t1"."SEX", "t1"."AGE", "t1"."HEIGHT", "t1"."WEIGHT", "t2"."TEST" FROM 
       "CLASS" "t1" INNER JOIN "CLASSJOIN" "t2" ON (t1.NAME = t2.NAME).

When joining three or more tables, the join is rewritten on the WHERE clause, and alias and column names are not enclosed within quotation marks.

Currently, the workaround is to copy the generated code into a program node and manually edit the code.

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

Operating System and Release Information

A fix for this issue for SAS Enterprise Guide 5.1 is available at:

A fix for this issue for SAS Add-in for Microsoft Office 5.1 is available at: