Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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:

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

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 :