TRIM

TRIM

Removes trailing blanks from character expressions and returns one blank if the expression is missing

Category: Character

Syntax
Arguments
Details
Comparisons
Examples
	Example 1: Removing Trailing Blanks
	Example 2: Concatenating a Blank Character Expression
See Also

Syntax

TRIM(argument)

Arguments

argument: specifies any SAS character expression.

Details

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

Assigning the results of TRIM 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 TRIM and TRIMN functions are similar. TRIM returns one blank for a blank string. TRIMN returns a null string (zero blanks) for a blank string.

Examples

Example 1: Removing Trailing Blanks

These statements and this data line produce these results:

data test;
   input part1 $ 1-10 part2 $ 11-20;
   hasblank=part1||part2;
   noblank=trim(part1)||part2;
   put hasblank;
   put noblank;
   datalines;

Data Line Results

apple sauce

----+----1----+----2

apple sauce

applesauce

Data Line	Results
apple sauce	----+----1----+----2
	apple sauce
	applesauce

Example 2: Concatenating a Blank Character Expression

SAS Statements Results

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

A B

x=" "; y=">"||trim(x)||"<"; put y;

> <

See Also

SAS Statements	Results
x="A"\|\|trim(" ")\|\|"B"; put x;	A B
x=" "; y=">"\|\|trim(x)\|\|"<"; put y;	> <

Functions:

COMPRESS

LEFT

RIGHT

Chapter Contents
Previous
Next
Top of Page