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