The STRIP() function is now passed down to Teradata as the TRIM()
function so that the STRIP() operation can be performed on the database
server and thus improve performance.  There is, however, one difference
between the semantics of SAS's STRIP() function and Teradata's
TRIM() function.  STRIP on a column composed entirely of blanks
evaluates to NULL while the Teradata equivalent TRIM(' ') does not.

For example, STRIP(' ') is NULL while TRIM(' ') is NOT NULL.  This can
be remedied by using STRIP(' ') = '' since that will evaluate to
TRIM(' ') = '' when pushed down to the database server and produce
the same results.


A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014931

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014931

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :