TRANSLATE

TRANSLATE

Replaces specific characters in a character expression

Category: Character

Syntax
Arguments
Details
Comparisons
Examples
See Also

Syntax

TRANSLATE(source,to-1,from-1<,...to-n,from-n>)

Arguments

source

specifies the SAS expression that contains the original character value.

to

specifies the characters that you want TRANSLATE to use as substitutes.

from

specifies the characters that you want TRANSLATE to replace.

Interaction:

Values of to and from correspond on a character-by-character basis; TRANSLATE changes character one of from to character one of to, and so on. If to has fewer characters than from, TRANSLATE changes the extra from characters to blanks. If to has more characters than from, TRANSLATE ignores the extra to characters.

Operating Environment Information: You must have pairs of to and from arguments on some operating environments. On other operating environments, a segment of the collating sequence replaces null from arguments. See the SAS documentation for your operating environment for more information. [cautionend]

Details

The maximum number of pairs of to and from arguments that TRANSLATE accepts depends on the operating environment you use to run SAS. There is no functional difference between using several pairs of short arguments, or fewer pairs of longer arguments.

Comparisons

The TRANWRD function differs from TRANSLATE in that it scans for words (or patterns of characters) and replaces those words with a second word (or pattern of characters).

Examples

SAS Statements Results

x=translate('XYZW','AB','VW'); put x;

XYZB

See Also

SAS Statements	Results
x=translate('XYZW','AB','VW'); put x;	XYZB

Function:

TRANWRD

Chapter Contents
Previous
Next
Top of Page