SAS Programming Advance Certification Course(SAS SQL, Macro)

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