sas-training-courses
7832  Reviews star_rate star_rate star_rate star_rate star_half

SAS(R) Programming 3: Advanced Techniques

This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures. The course builds on the concepts that are presented in the SAS® Programming 2: Data...

Read More
$1,600 USD GSA  $1,446.35
Course Code PG3M6
Available Formats Classroom

This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures. The course builds on the concepts that are presented in the SAS® Programming 2: Data Manipulation Techniques course.

Skills Gained

  • Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW).
  • Perform pattern matching using PRX functions.
  • Process repetitive code, rotate data, and perform table lookups using arrays.
  • Perform table lookups and sort data using hash and hash iterator objects.
  • Create numeric templates using the FORMAT procedure.
  • Create custom functions using the FCMP procedure.

Who Can Benefit

  • Experienced SAS programmers

Prerequisites

  • Before attending this course, you should have completed the SAS® Programming 2: Data Manipulation Techniques course or have equivalent knowledge. Specifically, you should be able to do the following:
  • Create an accumulating column and process data in groups.
  • Manipulate data with functions.
  • Convert column types.
  • Create custom formats.
  • Concatenate and merge tables.
  • Process repetitive code.
  • Restructure tables.

Course Details

Getting Started

  • Setting up for this course.
  • DATA step review.

Using Advanced Functions

  • Using a variety of advanced functions.
  • Performing pattern matching with Perl regular expressions.

Defining and Processing Arrays

  • Defining and referencing one-dimensional arrays.
  • Doing more with one-dimensional arrays.
  • Defining and referencing two-dimensional arrays.

Defining and Processing Hash Objects

  • Declaring hash objects.
  • Defining hash objects.
  • Finding key values in a hash object.
  • Writing a hash object to a table.
  • Using hash iterator objects.

Using Utility Procedures

  • Creating picture formats with the FORMAT procedure.
  • Creating functions with the FCMP procedure.