The SQL Join transformation within SAS^® ETL Studio may generate program code with excessive line lengths. This problem is most likely to occur in the WHERE and HAVING clauses.

If the line length exceeds the maximum for the method you are using to submit your code (see #015883 for these limitations), your program will not execute correctly. The results you receive can vary from pop up Error dialog boxes to Warnings like the following in the SAS Log:

In the cases where the submitted code gets truncated due to excessive line length, and this truncation does not result in an error, the job may continue to run but unexpected results can occur.

One workaround for this problem is to define the entire expression in the WHERE or HAVING tab as a macro earlier in your job definition, then invoke this macro in the appropriate tab in place of the entire code.

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

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :