Problem Note 56746: The Expression Builder in SAS® Data Integration Studio incorrectly modifies expression content, which might result in run-time errors
 |  |  |  |  |
Text that you enter in an expression on the Mappings tab of any transformation might be incorrectly modified when you save the 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 TableName when you save.
This modification is caused by the Expression Builder incorrectly tokenizing the expression when a save is executed. The general intention of the tokenizer is to identify key words like column names and add qualifiers (such as Libref) if none are 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:
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.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2003 for x64 | 4.4 | 9.3 TS1M1 | ||||
| Microsoft Windows Server 2008 | 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 for x64 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 | ||
| Microsoft Windows XP Professional | 4.4 | 9.3 TS1M1 | ||||
| Windows 7 Enterprise 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 Home Premium 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 Professional 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 Ultimate 32 bit | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 4.4 | 4.902 | 9.3 TS1M1 | 9.4 TS1M4 | ||
| Windows Vista | 4.4 | 9.3 TS1M1 | ||||
| Windows Vista for x64 | 4.4 | 9.3 TS1M1 | ||||
A fix for this issue for Data Integration Studio 4.901 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W51.html#56746| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-01-20 16:02:46 |
| Date Created: | 2015-10-07 15:25:34 |