When you load a Teradata table to CAS, a WHERE clause might not be passed to the Teradata database. Instead, the SAS^® Embedded Process does the subsetting when the following is true:

• The loading is being done in parallel through the DATATRANSFERMODE=PARALLEL option.
• A WHERE= option is being used instead of a DBMSWHERE= option.

Also, when the VARLIST= option is specified, a SELECT statement with all variables might be passed to the database. SAS Embedded Process selects the specified list of variables that is pulled into SAS.

There is no workaround for this issue.