3 arrows

Get 50% Off ForgeRock Training Bundles

closeClose

SAS(R) Programming 3: Advanced Techniques

  • Tuition USD $1,450
  • Reviews star_rate star_rate star_rate star_rate star_half 3224 Ratings
  • Course Code PG3M6
  • Duration 2 days
  • Available Formats Classroom, Virtual

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.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Very educational and informative. Instructor was very Interactive so I had great learning. Presentation is very good. Venue is very convenient.

The class provided by ExitCertified was well put together, with a great instructor and thorough course materials.

I had a good experience with ExitCertified. I got a deeper understanding of AWS and should be able to put it to practice immediately.

This course gave me a clearer understanding of the AWS cloud architecture.

This was a great training class. The instructor explained the concepts very well and covered all topics in detail also allowing sufficient time for labs.

11 options available

undo
  • Jun 21, 2021 Jun 25, 2021 (5 days)
    Location
    Virtual
    Language
    English
    Time
    1:00 PM 4:30 PM EST
    Enroll
    Enroll
  • Jul 12, 2021 Jul 16, 2021 (5 days)
    Location
    Virtual
    Language
    English
    Time
    1:00 PM 4:30 PM EST
    Enroll
    Enroll
  • Aug 2, 2021 Aug 6, 2021 (5 days)
    Location
    Virtual
    Language
    English
    Time
    1:00 PM 4:30 PM EST
    Enroll
    Enroll
  • Aug 5, 2021 Aug 6, 2021 (2 days)
    Location
    Virtual
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Aug 16, 2021 Aug 20, 2021 (5 days)
    Location
    Virtual
    Language
    English
    Time
    1:00 PM 4:30 PM EST
    Enroll
    Enroll
  • Sep 20, 2021 Sep 24, 2021 (5 days)
    Location
    Virtual
    Language
    English
    Time
    1:00 PM 4:30 PM EST
    Enroll
    Enroll
  • Oct 18, 2021 Oct 22, 2021 (5 days)
    Location
    Virtual
    Language
    English
    Time
    1:00 PM 4:30 PM EST
    Enroll
    Enroll
  • Oct 20, 2021 Oct 21, 2021 (2 days)
    Location
    Virtual
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Oct 25, 2021 Oct 26, 2021 (2 days)
    Location
    Virtual
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Nov 8, 2021 Nov 12, 2021 (5 days)
    Location
    Virtual
    Language
    English
    Time
    1:00 PM 4:30 PM EST
    Enroll
    Enroll
  • Dec 6, 2021 Dec 7, 2021 (2 days)
    Location
    Virtual
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward