Previous Page | Next Page

Functions and CALL Routines

TRIMN Function



Removes trailing blanks from character expressions, and returns a string with a length of zero if the expression is missing.
Category: Character
Restriction: I18N Level 0

Syntax
Arguments
Details
Length of Returned Variable
The Basics
Comparisons
Examples
See Also

Syntax

TRIMN(argument)


Arguments

argument

specifies a character constant, variable, or expression.


Details


Length of Returned Variable

In a DATA step, if the TRIMN function returns a value to a variable that has not previously been assigned a length, then that variable is given the length of the argument.

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.


The Basics

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 string with a length of zero. TRIMN is useful for concatenating because concatenation does not remove trailing blanks.


Comparisons

The TRIMN and TRIM functions are similar. TRIMN returns a string with a length of zero 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

Functions:

COMPRESS Function

LEFT Function

RIGHT Function

TRIM Function

Previous Page | Next Page | Top of Page