Problem Note 46831: The Query Builder in SAS® Enterprise Guide® might not correctly process explicit pass-through code and joins
 |  |  |  |  |
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Windows 7 Enterprise 32 bit | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows Vista | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 5.1 | 6.1 | 9.3 TS1M0 | 9.3 TS1M0 | ||