The ability to pass the SAS TRIM function as the RTRIM function in the query that is passed to the Google BigQuery database has been added. This function might be passed if one of the following conditions is true about the query:

• The function is used in the WHERE clause.
• The function appears in the SELECT, GROUP BY, HAVING, or ORDER BY clause; the query contains a condition that triggers implicit pass-through; and the query does not include a condition that would prevent the entire query from being passed to the database. 

Some triggers for implicit pass-through are as follows:

• the DISTINCT keyword
• the ORDER BY clause
• a summary function/GROUP BY clause
• the joins of multiple BigQuery tables
• a HAVING clause

Some of the conditions that would prevent the entire query from being passed to the database include the following:

• if the DBMS does not accept the generated SQL syntax
• the query involves multiple librefs that do not share connection characteristics
• the query includes the use of data set options
• the use of certain LIBNAME options
• the use of certain SAS functions

Click the Hot Fix tab in this note to access the hot fix for this issue.

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

A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.42 is available at:

A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.41 is available at: