Return to Archive

SAS Tip of the Month
February 2006

When the TRIM function is used on a string, the trailing blanks are removed. But did you know that if the string is blank then a single ‘blank’ character is inserted?

But what if we want a ‘null’ string instead?

There is an interesting function called TRIMN that removes trailing blanks from character expressions and returns a null string if the expression is missing.

Updated February 1, 2006