Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - Substr Function

The video tutorial explains the substring function, focusing on its syntax and arguments: source, position, and number of characters to read. It demonstrates how to extract specific data from a date variable using the substring function. The tutorial also covers the left side application of substring, showing how to modify parts of a string, such as changing a year in a date. The video aims to make the concept clear and easy to understand through examples.

What is the first argument in the substring function?

• Position

• Length

• Variable

• Source

In the substring function, what does the 'position' argument specify?

• The type of data to read

• The ending point for reading

• The starting point for reading

• The number of characters to read

How many characters are read if the length argument is set to 5?

• 3

• 4

• 6

• 5

What is the purpose of the left side application of the substring function?

• To delete a substring

• To add new characters

• To change a few characters

• To extract a substring

In the left side application example, what year was the original '98' changed to?

• 2016

• 2018

• 2020

• 2008