059-30: A Clever Demonstration of the SAS® SUBSTR Function
SUGI 30
Coders' Corner
Paper 059-30
A Clever Demonstration of the SAS? SUBSTR Function
David J. Austin, Quintiles, Inc., Kansas City, MO
ABSTRACT
The SAS? SUBSTR function differs from the substring function in other programming languages as it can be used on either side of the assignment operator. This paper demonstrates its practical usage by building programs to separate and manipulate text. Specific topics include: Proper Syntax Use; Comparison with the COLON MODIFIER; Left-hand Side Usage; Use in Conjunction with the INDEX Function; Usage on Both Sides; Usage in an Align MACRO; and finally, Simple Encryption Techniques for Creating Cryptograms. The demonstrations should be useful to both beginner and intermediate SAS users.
INTRODUCTION: PROPER SYNTAX USE
The syntax for the SUBSTR function on the left-hand side of the equal sign is: SUBSTR( string, starting position ) = `characters-to-replace', while the right-hand side syntax is: SUBSTR( string, starting position ). Syntax illustrated using angle brackets (` ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- the essential functions of r
- r reference card
- functions function output syntax sample result
- c reference card ansi constants flow of control program
- r language definition
- python cheat sheet
- using keystrokes to write equations in microsoft office
- syntax becomes rstudio
- 059 30 a clever demonstration of the sas substr function
- three ways to add texts to graphics in proc sgplot sas
Related searches
- function of the vice president
- clever quote of the day
- live demonstration of edex injection
- function of the heart
- period of the function calculator
- sas put function numeric to character
- sas put function examples
- the function of the mouth
- what is the function of the thyroid
- what is the function of the prostate
- a brief history of the internet pdf
- the main function of the digestive system