PATTERN Function

Indicates whether a string has numbers, uppercase characters, and lowercase characters.

Category: String
Returned data type: String
Syntax
Required Argument
Details
Example

Syntax

PATTERN(string)

Required Argument

string

specifies a string that is to be evaluated for numbers, uppercase characters, and lowercase characters; this can be specified as fixed string, field name, or expression

Note If string is NULL, the function returns a NULL value. If string is empty (""), an empty value is returned.

Details

The returned string contains a 9 in place of each number, an “A” for each uppercase character, and an “a” for each lowercase character. Other characters are not replaced.

Example 

source_string = "12/b Abc-Str."
result = pattern(source_string) // outputs "99/a Aaa-Aaa."
Copyright © SAS Institute Inc. All rights reserved.