SAS functions by example

Description

This course is presented by Ron Cody , author of Cody's Data Cleaning Techniques Using SAS Software.

There are hundreds of SAS functions that can be used to solve a variety of programming problems. This course covers many of the most popular SAS functions, including many of the new SAS 9 functions. Every function discussed in the course is demonstrated by one or more examples, showing typical and not so typical applications. In addition, you have a chance to try out all these functions in class exercises.

Prerequisite Skills

Before attending this course, participants should have completed the SAS Essentials: An Introduction to SAS Programming course. Completion of the SAS® Programming: Data Manipulation Techniques course is also recommended or, alternatively, a minimum of one year of SAS programming experience. Some familiarity with arrays, DO loops, the FIRSTOBS and LASTOBS options would be useful but is not essential.

SAS Modules Used

This course Base SAS, SAS/GRAPH.

Course Topics

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