SAS PROC SQL TRIM STATEMENT

Question

I am having problems with a TRIM st

This is the error that I am receiving;

ERROR: CLI prepare error: [Teradata][ODBC Teradata Driver][Teradata Database]
       Syntax error, expected something like ')' between a string or a Unicode
       character literal and the integer '9'.

And this is a sample of the code it is refering to;

select trim(a.BR_CBS_CUST(FORMAT "9(4)")) || trim(a.STEM_CBS_CUST(FORMAT "9(6)")) || 
  trim(a.ACTP_CBS_CUST) || trim(a.CDG_CBS_CUST)  (char(20))as CUSTNO

Can anyone tell me what is wrong with the code?

Thanks.

Answer 1

Consider COMPRESS() which can be helpful when removing blanks and concatinating strings.

Answer 2

Did you try LTRIM RTRIM Instead normal Trim?