SAS Data Integration Studio jobs that contain the Table Loader transformation might generate the following error:  

   ERROR:  Variable <variable name> is not on file <table name>.

This issue occurs when the following conditions are met:

• Specify a WHERE condition on the table Options tab, which is in the properties of the Table Loader transformation.
• The column in the WHERE condition is dropped from the target table of the Table Loader transformation.

SAS^® Data Integration Studio 4.910 generates code that prematurely deletes the columns that are not in the target table. This error occurs because the column is no longer available for use when the WHERE condition is applied to filter the data. 

The code is generated correctly in SAS^® Data Integration Studio 4.905 and SAS^® Data Integration Studio 4.906. 

Workaround

To work around this issue, specify the WHERE condition as an option for the source table instead of specifying the condition in the properties of the Table Loader transformation. However, note that the option is applied to any job or transformation that uses the metadata table object.