Problem Note 16460: Expression Builder may generate source code with excessive line lengths
The Expression Builder, accessed via the MAPPING tab in most SAS® ETL
Studio transformations, does not successfully preserve carriage returns
/ line feed characters. Therefore, the program code generated from these
expressions can have excessive line lengths.
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:
Warning: Truncated Record.
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 as a
macro earlier in your job definition, then invoke this macro in the
Expression Builder window.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS Data Integration Studio | Microsoft Windows XP Professional | 3.2 | 3.2 |
| Microsoft Windows NT Workstation | 3.2 | 3.2 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 3.2 | 3.2 |
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 3.2 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 3.2 |
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 3.2 |
| Microsoft Windows 2000 Server | 3.2 | 3.2 |
| Microsoft Windows 2000 Advanced Server | 3.2 | 3.2 |
| Microsoft Windows 2000 Datacenter Server | 3.2 | 3.2 |
| Microsoft Windows 2000 Professional | 3.2 | 3.2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2006-04-26 09:26:29 |
| Date Created: | 2005-11-09 14:30:29 |