SAS® Programming 3: Advanced Techniques
START FREE TRIAL
Available in:
Education Category Image


  
SAS® Programming 3: Advanced Techniques
Duration: 14 hours
PROG3 : PG3M6
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 Should Attend
    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.
    • SAS Products Covered
    Base SAS
    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.

    • Live Instructor Dates SOLD SEPARATELY
    DATES ▼ LOCATION ▲
    ▼    		 TIME ▲
    ▼    		LANGUAGEEVENT FEE
    02-05 JUN 2025Live Web, US10:30 AM-2:30 PM EDTSpanish1,600 USD
    09-13 JUN 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    14-18 JUL 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    11-15 AUG 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    18-21 AUG 2025Live Web, US10:30 AM-2:30 PM EDTSpanish1,600 USD
    15-19 SEP 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    13-17 OCT 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    30-31 OCT 2025Live Web, US9:00 AM-5:00 PM EDTEnglish1,600 USD
    08-12 DEC 2025Live Web, US1:00 PM-4:30 PM ESTEnglish1,600 USD
    sas certification badge

    This course helps prepare you to earn the following SAS Credentials:


    SAS Certification Manager

    SAS partners with Pearson VUE to provide you with the best possible certification experience.

    Login


    Certification Resources

    certification home icon

    Certification Home
    webinars icon

    Webinars
    exam preparation icon

    Exam Preparation

    THIS COURSE IS PART OF

    SAS Advanced Programming Professional Subscription



    Skip Earn this badge

    Earn this badge

    Badge Image