SAS Institute CanadaSAS Institute Canada
We deliver superior software and services that give people the power to make the right decisions. News & Press Contact Information sas.com Profile Jobs at SAS Canada
Home Products & Solutions Customers SAS Canada Events Services & Support www.sas.com

SAS Functions by Example

Business Knowledge Series course

Duration: 2.0 days
Course fee: $1,940
EPTO units: 3
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.
Register now

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.

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

[SAS Institute Inc.]
This page was created using SAS software.
The Power to Know
   Contact Us     Search     Terms of Use & Legal Information     Privacy Statement   Copyright © 2007 SAS Institute Inc. All Rights Reserved