Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

SAS Programming Advance Certification Course(SAS SQL, Macro)

via Udemy

Overview

The complete Prep Course for SAS Advanced Programming Professional Certification SAS® 9.4 (Exam ID A00-232)

What you'll learn:
  • Suitable for both the traditional and the new practical SAS® Certified Professional: Advanced Programming Using SAS® 9.4
  • the most complete SAS Advanced programming certification course
  • SAS Advanced Programming Techniques and Efficiencies (the only Udemy course contains this content)
  • SAS SQL (SAS Proc SQL)
  • SAS Macro

Course Highlights:

  • The complete Preparation Course for SAS® Certified Professional: Advanced Programming Using SAS® 9.4 (Exam ID A00-232)

  • The course includes all 3 advanced SASprogramming topics (SAS Macro, SAS SQL, Advanced Techniques and Efficiencies) which are required by SAS® Certified Professional: Advanced Programming Using SAS® 9.4 (Exam ID A00-232)

  • over 135 video-based lectures, 16 hours long self-paced course

  • step by step/code by code explanations for easy and efficient learning

  • downloadable course materials including SASprograms and data used in the course

  • quizzes, coding exercises and practical examples are offered for practice

  • Notes on Course ratings and reviews:

    Please be considerate and sincere when you provide ratings. This will encourage me providing more contents to the course and better service to you. Thank you!

Course Description:

Do you want to learn SAS programming advanced topics and become SAS®Certified Advanced professionals? This course include ALL 3 SASAdvanced programming topics included in the SASAdvanced programming certification exam:

  • SAS SQL (Proc SQL) : 8 hours long and over 60 video-based lectures (all sections start with "SAS SQL")

  • SAS Macro Language : 4 hours long and over 40 video-based lectures (all sections start with "SAS Macro")

  • Advanced Programming Techniques and Efficiencies: 4 hours long and over 35 video-based lectures (all sections start with "Advanced Techniques and Efficiencies")

SAS SQL (Proc SQL) : 8 hours long and over 60 video-based lectures:

sections are:

  • SELECT Statement

  • JOIN

  • Subqueries

  • Combine Queries

  • Creating and Updating Tables and Views

  • Practical Examples Using PROC SQL

SAS Macro Language : 4 hours long and over 40 video-based lectures

sections are:

  • SAS Macro programming introduction:

  • Create and Use Macro variables and Macro Functions:

  • Create and Use Macro Programs:

  • Create and Use macro variables during execution of a data step:

  • Create and Use macro variables during execution of a proc SQL step:

Advanced Programming Techniques and Efficiencies: 4 hours long and over 35 video-based lectures

sections are:

  • Advanced Techniques and Efficiencies: Indexes

  • Advanced Techniques and Efficiencies: Combining Data Vertically

  • Advanced Techniques and Efficiencies: Combining Data Horizontally

  • Advanced Techniques and Efficiencies: Formats & Arrays

  • Advanced Techniques and Efficiencies: Perform effective benchmarking

  • Advanced Techniques and Efficiencies: Controlling Data Storage Space

  • Advanced Techniques and Efficiencies: PROC FCMP: functions and subroutines

  • Advanced Techniques and Efficiencies: Compare techniques to eliminate duplicates


REFERENCE:

SAS 9.4 SQL Procedure User's Guide, Second Edition

SAS® 9.4 Macro Language: Reference, Fifth Edition

SAS certification prep guide: advanced programming for SAS 9 by SAS Institute

Note: The course was created with SAS softwarelicensefor the SAS University Edition (the downloadable SASstudio version).

The course is also suitable to use with SASOnDemand for Academics (the web-based SASstudio version).

The software interface/appearance and functionalities in the two SAS studio versions are the same.

Section 2 has all the details for using SASOnDemand for Academics with this courses.

Taught by

Sharon Cheng

Reviews

4.5 rating at Udemy based on 1053 ratings

Start your review of SAS Programming Advance Certification Course(SAS SQL, Macro)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.