Problem Note 18526: Lookup transformation code fails with ERROR: The name "columnname"n is not a valid SAS name
 |  |  |  |  |
A SAS® Data Integration Studio job will fail with the error listed in the title under the following conditions:
- The job contains a Lookup transformation and one or more of the lookup definitions have an Exception defined as Condition Code="Lookup Value Not Found", then Action="Set Target Column Value to Missing".
- One or more of the tables referenced within the SAS Data Integration Studio job have the "Enable special characters within DBMS object names" attribute set.
When this combination exists, the variable names in the CALL MISSING statement get generated with nested name-literal references. An example of the invalid code is as follows:
call missing ('"Name"n'n, '"Age"n'n);
When the correct code should be:
call missing ("Name"n, "Age"n);
The only workaround is to remove the "Enable special characters within DBMS object names" from all tables, if the option is not actually needed.
Select 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 NT Workstation | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows XP Professional | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Server | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Advanced Server | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Datacenter Server | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
| Microsoft Windows 2000 Professional | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 | ||
A fix for this issue for SAS Data Integration Studio 3.4 is available at:
http://www.sas.com/techsup/download/hotfix/dis34.html#018526| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2006-09-29 12:02:02 |
| Date Created: | 2006-09-15 10:59:47 |