SUPPORT / SAMPLES & SAS NOTES
Problem Note 49995: Code for the macro variable OPTEmitSQL is incorrect when the prompt type Data Source Column is used with the option "Emit SQL Syntax for column"
 |  |  |  |  |
A Generated transformation for which a prompt is defined results in incorrect code under the following conditions:
- The Data Source columns are selected from two or more different source tables.
- The prompt type Data Source Column is used.
- The option Emit SQL syntax for columns is selected.
The code that is generated for the macro variable OPTEmitSQL only refers to one table, as shown in the following example:
%let OPTEmitSQL = TABLE1.Table1_Col, TABLE1.Table2_Col, TABLE1.Table-n_Col;
The code should read as follows:
%let OPTEmitSQL = TABLE1.Table1_Col, TABLE2.Table2_Col, TABLE-n.Table-n_Col;
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 Data Integration Studio | Microsoft® Windows® for x64 | 4.2 | 4.7 | 9.2 TS2M0 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2003 for x64 | 4.2 | 9.2 TS2M0 | ||||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.7 | 9.2 TS2M0 | 9.4 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 9.2 TS2M0 | ||||
| Windows Vista | 4.2 | 9.2 TS2M0 | ||||
| Windows Vista for x64 | 4.2 | 9.2 TS2M0 | ||||