How Do You Substr in Sas

The syntax for the SUBSTR function on the left-hand side of the equal sign is: SUBSTR( string, starting position <, length> ) = ‘characters-to-replace’, while the right-hand side syntax is: <variable = > SUBSTR( string, starting position <, length>). Syntax illustrated using angle brackets (‘<‘ and ‘>’) is optional.

How do I extract a character in SAS?

1. You can use the SUBSTR() function in combination with the LENGTH() or REVERSE() function to extract the last character from a string in SAS. …
2. The first method to get the last character from a string combines the power of the SUBSTR() function and the LENGTH() function.

How do I extract the first letter in SAS?

Substring in SAS is accomplished by using SUBSTR() Function. SUBSTR() Function takes up the column name as argument and calculates the substring. Extract first N Character and Extract Last N Characters in SAS is accomplished using SUBSTR() Function.