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.

Create custom functions using the FCMP procedure.

Who should attend

Experienced SAS programmers

Formats available	Standard Duration
Classroom:	2.0 days
Live Web Classroom:	5 half-day session(s)	System Requirements
e-Learning:	24 hours/180 day license	System Requirements

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.

This course addresses Base SAS software.

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

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

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

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

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