TRIMN

TRIMN

Removes trailing blanks from character expressions and returns a null string (zero blanks) if the expression is missing

Category: Character

Syntax
Arguments
Details
Comparisons
Examples
See Also

Syntax

TRIMN(argument)

Arguments

argument: specifies any SAS character expression.

Details

TRIMN copies a character argument, removes all trailing blanks, and returns the trimmed argument as a result. If the argument is blank, TRIMN returns a null string. TRIMN is useful for concatenating because concatenation does not remove trailing blanks.

Assigning the results of TRIMN to a variable does not affect the length of the receiving variable. If the trimmed value is shorter than the length of the receiving variable, SAS pads the value with new blanks as it assigns it to the variable.

Comparisons

The TRIMN and TRIM functions are similar. TRIMN returns a null string (zero blanks) for a blank string. TRIM returns one blank for a blank string.

Examples

SAS Statements Results

x="A"||trimn("")||"B"; put x;

AB

x=" "; z=">"||trimn(x)||"<"; put z;

><

See Also

SAS Statements	Results
x="A"\|\|trimn("")\|\|"B"; put x;	AB
x=" "; z=">"\|\|trimn(x)\|\|"<"; put z;	><

Functions:

COMPRESS

LEFT

RIGHT

TRIM

Chapter Contents
Previous
Next
Top of Page