All Articles

Upper

%UPPER returns the string operand, with all or part of the operand converted to...

Uns

The expression’s value is converted to unsigned format using %UNS. Any decimal digits are...

Trimr

The %TRIMR function is used to remove a string’s trailing blank spaces. Other than...

Triml

The %TRIML method is used to remove a string’s leading blank spaces. Other than...

Trim

To remove blank space from a string on both sides, use the %TRIM function....

Timestamp

To convert a string into a timestamp data type, use the %TIMESTAMP method. Syntax:...

Subst

The string is partially extracted from any point using the %SUBST method. The source...

Subdt

A subset of the data in a date, time, or timestamp value is extracted...

Status

The program or file status’s most recent value is returned by the %STATUS function....