Problem Note 56809: Expressions defined in the SQL Join transformation in SAS® Data Integration Studio are incorrectly modified, which might result in run-time errors
Text that you enter into an expression in one of the following locations in the SQL Join transformation might be incorrectly modified when you save the expression:
- Join expression
- Where expression
- Select expression
Specifically, this problem affects text in the Libref.TableName expression, where the expression matches the Libref and TableName of a source table in the transformation. The expression is modified to just the Libref when you save.
This modification is caused by the Expression Builder incorrect tokenizing the expression when a save is executed. The general intention of the tokenizer is to identify key words like TableName and add qualifiers (such as Libref) if none are not present.
You might encounter errors during job execution due to this removal of content.
To work around this issue, quote the string to prevent tokenization, and then use SAS functions to remove the quotation marks. For example, you would enter Libref.TableName as shown here:
%sysfunc(compress("LIBREF.TABLENAME",'"'))
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Data Integration Studio | Windows Vista for x64 | 4.4 | | 9.3 TS1M1 | |
Windows Vista | 4.4 | | 9.3 TS1M1 | |
Windows 7 Ultimate x64 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Windows 7 Ultimate 32 bit | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Windows 7 Professional x64 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Windows 7 Professional 32 bit | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Windows 7 Home Premium x64 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Windows 7 Home Premium 32 bit | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Windows 7 Enterprise x64 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Windows 7 Enterprise 32 bit | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Microsoft Windows XP Professional | 4.4 | | 9.3 TS1M1 | |
Microsoft Windows Server 2008 for x64 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Microsoft Windows Server 2008 R2 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Microsoft Windows Server 2008 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
Microsoft Windows Server 2003 for x64 | 4.4 | | 9.3 TS1M1 | |
Microsoft Windows Server 2003 Standard Edition | 4.4 | | 9.3 TS1M1 | |
Microsoft Windows Server 2003 Enterprise Edition | 4.4 | | 9.3 TS1M1 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.4 | | 9.3 TS1M1 | |
Microsoft® Windows® for x64 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
*
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.
Text that you enter in an expression in the SQL Join transformation might be incorrectly modified when the expression is saved.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2016-01-20 16:04:19 |
Date Created: | 2015-10-16 11:20:27 |