• Print |
• E-mail  |
• Bookmark

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

A fix for this issue for SAS Data Integration Studio 3.4 is available at: