Exampler.org SAS PYTHON HTML

SAS Introduction

SAS Case Stmnt.

SAS Change type

SAS Concatenate

SAS Create Table

SAS Input Stmt.

SAS Financial Functions

SAS SUBSTR

What is it?

Replaces text or a string based on position, variable and or an expression

Syntax:

SUBSTR(STRING, start_position, #_of_characters_to_change) = 'new_string';

SAS SUBSTR Statement:

SAS SUBSTR Example:

Data work.my_data_file;

variable_a = "Roses are Red";
Result_1 = SUBSTR(variable_a, 1, 7) = 'Wine is';

Run;

What's happening in the script above?

The SUBSTR(); Function is replacing 'Roses are Red' with 'Wine is Red'
The 'R' in the word Red is the 1st character
'Wine is' is 7 characters long
'Wine is' replaces the word red

SUBSTR Example:

Variable	Input	Output	Description
variable_a	Roses are Red	Win is Red

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.