SAS Financial Functions

SAS Scan Function

What is it?

Enables you to extract out a word from a string or text while ignoring punctuation
Function has modifiers [site needs updating to include modifiers]

Syntax:

Scan(String, Integer);
Scan(String, Integer, 'delimeter');

SAS Scan Function Example:

Data work.my_data_file;

    some_text = 'From the window, to the wall.';
    Result_1 = scan(some_text, 1);
    Result_2 = scan(some_text, 2);
    Result_3 = scan(some_text, 3);
    Result_4 = scan(some_text, 4);
run;

What's happening in the script above?

Examples of the Scan function; essentially, the string is being passed to the scan function, the integer indicates the word #
Additionally, the negative number indicates that the word selection is working from the end of the text.

SAS Scan Function Examples:

Variable	Input	Output	Description
Result_1	From the window, to the wall.	From	1st Word
Result_2	From the window, to the wall.	the	2nd Word
Result_3	From the window, to the wall.	window	3rd Word
Result_4	From the window, to the wall.	wall	Last Word

Connect via LinkedIn

Kevin Regan

Have an article, idea, found a typo, want to contribute? Shoot me an email Here

Below are links to some Udemy Data Science Courses. I've been using Udemy for a number of years now, and I've found their courses super helpful, maybe you will also.