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.

• 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.

Zielgruppe / Who should attend

Verfügbare Schulungsformen / Formats available	Dauer (kann variieren, Details s. Terminliste)
Präsenzkurs:	2.0 Tage
Live Web Class:	17.5 Stunden	Systemvoraussetzungen
E-Learning:	14 Stunden/180 Tag Lizenz	Systemvoraussetzungen

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.

In diesem Kurs wird mit folgenden Software Modulen gearbeitet / 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.