When SAS^® Cloud Analytic Services (CAS) libraries interact with SAS/ACCESS^® Interface to Teradata, you might observe the following issues:

• Poor performance
• No Teradata tables are listed in a CAS library

These issues can occur because SAS^® software refers to the X versions of Teradata views, and these views take security into consideration. Non-X views are faster; however, they do not consider security.

Unconditional SELECT statements that are executed on non-X views might cause the result to exhaust the available spool space of the user. For more information about querying X views versus non-X views, refer to the Teradata documentation.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

After you install the hot fix, in order to use non-X views, you need to set the environment variables SAS_NON_XVIEWS and SAS_NON_XVIEW_TABLES.

On each CAS node, use a text editor to edit the cas_usermods.settings file:

Add the following lines:

Operating System and Release Information

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at