Welcome to ONLC Training Centers

SAS Advanced Programming Course

Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $795

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


SAS Advanced Programming Course

 

Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

Overview

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.

Learn How To

• 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 this class is for?

Experienced SAS programmers who are familiar with simple SQL queries and well-versed in DATA step processing

Prerequisites

SAS Fundamentals and SAS intermediate courses.

Course Outline

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.

 

View outline in Word

XSAS03

Attend hands-on, instructor-led SAS Advanced Programming training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com