• phone icon +44 7459 302492 email message icon support@uplatz.com
  • Register
0- - 0
Job Meter = High

Advanced SAS SQL

Unlimited Hours
Online Instructor-led Training
USD 1399 (USD 2800)
Save 50% Offer ends on 30-Nov-2024
Advanced SAS SQL course and certification
318 Learners

About this Course
This course covers more advanced uses of SQL relevant to SAS Programmers who wish to build on their base knowledge. Specifically, the course goes into more depth around the subjects of joins, making queries more efficient and also how to use SQL pass-through.

----------------------------------------------------------------
Target Audience

SAS Programmers who wish to further their knowledge of SQL Programming within the SAS System.
----------------------------------------------------------------

Advanced SAS SQL

Course Details & Curriculum

SQLA1 Refresher

  • Proc SQL
  • Queries
  • Joins
  • Other SQL Statements

SQLA 2 Joins, Subqueries and In-Line Views

  • Natural Joins
  • Other Joins
  • Set Operators
  • Complex Queries
  • Subqueries
  • In-line Views

SQLA3 Handling SAS Tables

  • Indexes
  • Integrity Constraints
  • The DICTIONARY Tables and SASHELP Views

SQLA 4 Handling Database Tables

  • Pass-Through
  • Sorting Data From External Tables
  • The MODIFY Statement in Base SAS

SQLA 5 Other Topics (Optional)

  • Efficiency and Timing Performance
  • Execution Control, Error Handling and Exit Status
  • Proc SQL and the ANSI Standard
----------------------------------------------------------------

Didn't find what you are looking for?  Contact Us

course.php