Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

A SAS^® Data Integration Studio job will fail with the error listed in the title under the following conditions:

1. 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".
2. 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

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