SAS Institute. The Power to Know

Learning Center

Stay in Touch

Not sure what course to take?

Speak with an expert curriculum consultant at 800-333-7660 or send an e-mail.

Submit Your Course Requests

Want this course at another location or on a different date? Let us know your course needs.

On-site Pricing

Course fee and EPTO/APTO units differ for on-site training.

SAS Functions by Example

Business Knowledge Series course

Duration: 2.0 days
Course fee: $1,150
EPTO units: 2.2
CEUs: 1.2
Register now

Presented by Ron Cody, author of Cody's Data Cleaning Techniques Using SAS Software

This course covers many useful functions that can solve everyday problems quickly and efficiently and that are not discussed in other programming courses. It is ideal for anyone who programs in Base SAS, especially DATA step programming.

Learn how to

Who should attend

SAS programmers

Expand/Collapse AllExpand All      Expand/Collapse AllCollapse All      PrintPrint version

Prerequisites
Before attending this course, participants should have completed the SAS Programming I: Essentials course. Completion of the SAS Programming II: Manipulating Data with the DATA Step 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.
Course Contents
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
Software
This course addresses Base SAS, SAS/GRAPH.
Course Materials
Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.
Share Your Thoughts
Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Register now


created using SAS software This page was created using SAS software.