Usage Note 20708: The Lookup transformation generates a syntax error if the named literal
quoting is disabled in the last lookup table
The Lookup transformation in SAS® Data Integration Studio 3.4 will
generate invalid syntax if the last lookup table referenced in the
process flow has been defined to disable case sensitive names or special
characters within the table and column names. This will only occur if
the predecessor lookup tables are defined to enable case-sensitive
names or special characters in the names. These properties are defined
on the Physical Storage tab of the properties table and are only
likely to be set if the lookup table resides in a another database
structure such as Oracle or DB2.
An error similar to this will occur:
384 /* Build hash h0 from lookup table tempfold."OLELOOKUP1"n */
385 nlobs = .;
386 dsid = open("tempfold."OLELOOKUP1"n");
49 388 200
NOTE 49-169: The meaning of an identifier after a quoted string may
change in a future SASrelease. Inserting white space between a
quoted string and the succeeding identifier is recommended.
ERROR 388-185: Expecting an arithmetic operator.
ERROR 200-322: The symbol is not recognized and will be ignored.
Operating System and Release Information
| SAS System | SAS Data Integration Studio | Microsoft Windows NT Workstation | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Standard Edition | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Advanced Server | 3.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 3.2 | | 9.1 TS1M3 SP4 | |
*
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: | Usage Note |
| Priority: | medium |
| Date Modified: | 2007-08-21 14:57:02 |
| Date Created: | 2007-08-01 10:26:28 |
