Base SAS Software: Procedures

The SQL Procedure

The new BTRIM function trims a single character from the beginning, end or both beginning and end of a string.
The SQL procedure contains three new joins:
- The new CROSS JOIN produces the crossproduct of two tables.
- The new NATURAL JOIN selects rows from two tables that have equal values in columns that share the same name.
- The new UNION JOIN returns a union of the columns of both tables.
The new fold functions change the case of their arguments.
The new truncated string comparison operators compare two strings after making the strings the same length by truncating the longer string to the same length as the shorter string.
The new SUBSTRING function returns part of a character expression.
The LIKE condition has a new ESCAPE clause that overrides the default behavior of the _ (underscore) and the % (percent sign).