Text (Simple) Operators :: SAS® Visual Analytics 7.4: User's Guide

Concatenate

appends the second input string to the first input string.

For example, Concatenate('A', 'B') returns AB.

Contains

specifies that a matching value must contain the specified string.

For example,

'Catcher'
                                 Contains 'Cat'

returns true.

EndsWith

specifies that a matching value must contain the specified string at the end of the value.

For example,

'Catcher'
                                 EndsWith 'her'

returns true.

Format

applies a SAS format to the input value. Click the format field to select the format that you want to apply. The output from the Format operator is a string.

For example, Format(1015.35, 'DOLLAR6.2') returns $1,015.35 as a string value.

Note: Standard date formats in SAS Visual Analytics display date and datetime values in the locale of your browser. You can display date and datetime values in the locale of the data source by using national language formats. The names of national language formats begin with “NL.” For example, the NLDATE format displays date values by using the locale of the data source.

LowerCase

changes all of the characters in a text string to lowercase.

For example,

LowerCase('SAS
                                 INSTITUTE’)

returns sas institute.

NotContains

specifies that a matching value must not contain the specified string.

For example,

'Catcher'
                                 NotContains 'Dog'

returns true.

Parse

interprets a numeric or datetime value from the input string. Click the format field to select the format that is used to interpret the string. The output from the Parse operator is either a number or a datetime value, depending on the format that you select.

For example, Parse('15JAN2013', 'DATE9.') returns 15JAN2013 as a date value.

StartsWith

specifies that a matching value must contain the specified string at the start of the value.

For example,

'Catcher'
                                 StartsWith 'Cat'

returns true.

UpCase

changes all of the characters in the text string to uppercase.

For example,

UpCase('sas
                                 institute')

returns SAS INSTITUTE.