Business Knowledge Series course

Presented by Ron Cody, author of Cody's Data Cleaning Techniques Using SAS Software and SAS Functions by Example; or Mark Jordan, Technical Training Consultant, Education Division, SAS

Ever spent valuable time writing complex code only to later find a function that would have done the job for you? Discover the plethora of practical SAS functions that you haven't seen in other SAS programming courses, and start resolving your everyday programming problems more quickly and efficiently.

Learn how to

• magically manipulate character data with ease, using PERL Regular Expression (PRX) and other amazing character functions
• dominate datetime, date, and time values with the previously perplexing Date Interval functions
• save programming time and reduce programmer frustration with array functions
• easily compute descriptive statistics, including how to use the new SMALLEST and LARGEST functions
• use mathematical and special functions to streamline your code
• generate random numbers with ease
• manipulate the values in various variables with CALL SORTN and CALL SORTC routines.

Who should attend

Base SAS programmers who want to write more elegant, efficient DATA step and PROC SQL programs

Formats available	Standard duration
Classroom:	2.0 days

Before attending this course, participants should have completed the SAS Programming 1: Essentials course. Completion of the SAS Programming 2: Data Manipulation Techniques course is also recommended or, alternatively, a minimum of one year of SAS programming experience.

This course addresses Base SAS software.

Character Functions Part 1

• storage length of character variables
• functions that change case
• functions that extract and search for strings
• functions that join strings
• functions that remove blanks from strings or take strings apart
• functions that count substrings or characaters

Character Functions Part 2

• the ANY and NOT functions
• functions that replace words or characters
• functions that compare strings

Date and Time Functions

• SAS date functions
• SAS time functions
• SAS datetime functions
• SAS interval functions

Array functions

• the DIM function
• array boundaries and the related functions
• temporary arrays

Descriptive Statistics Functions

• functions that count missing and nonmissing values for SAS variables
• functions that compute descriptive statistics
• functions that determine the ordering of data values

Special Truncation and Mathematical Functions

• special functions
• functions to obtain values from previous functions
• truncation functions
• commonly used mathematical functions

Random Number Functions

• uniform random numbers
• randomly generated data sets
• selecting random subsets of a SAS data set
• random assignments of subjects
• random number call routine

Variable Information Functions

• selected V functions

Perl Regular Expresssion Functions

• writing regular expressions
• the PRX functions