Contact

Fundamental SAS SQL

Standard Course
£400 +VAT
per delegate
Tailored training enquiry Book Now
Course duration: 1 Day

This course covers Proc SQL in detail, concentrating on the use of SQL for existing SAS Programmers. Traditional SAS DATA steps and Proc steps are compared with using Proc SQL and efficiency issues are discussed.

Who is it for?

SAS Programmers who wish to know the benefits and role of SQL Programming within the SAS System.

Prerequisites

What you will learn

  • Introduction to Proc SQL
  • Concepts
  • Features of Proc SQL
  • Course Overview

  • Clauses in the Select Statement
  • Simple Examples
  • SELECT Clause
  • FROM Clause
  • WHERE Clause
  • ORDER BY Clause
  • GROUP BY Clause
  • HAVING Clause
  • SAS Data Set Options
  • Other Topics
  • Further Examples (Optional)

  • The FROM Clause Revisited
  • Join Schematics
  • Inner Joins
  • Outer Joins
  • Equivalent DATA Steps

  • Creating Tables
  • SQL Views
  • Changing Data in Tables
  • Changing the Structure of Tables
  • RESET Statement

  • What are Macro Variables?
  • Selecting INTO
  • Lists Using SEPARATED BY
  • Automatic Macro Variables Set by Proc SQL

Fundamental SAS SQL Course Dates

Our courses are live instructor-led and delivered virtually.

Back to Training

Related content

SAS Training
SAS Fundamentals
Read more
SAS Training
SAS Programming
Read more
SAS Training
SAS Base Certification Training Path
Read more
SAS Training
SAS Macro
Read more
SAS Training
Advanced SAS Macro
Read more
SAS Training
Advanced SAS Programming
Read more
SAS Training
SAS Viya Programming
Read more
SAS Training
Regression for Predictive Analytics
Read more
SAS Training
Advanced SAS SQL
Read more
SAS Training
Fundamental Business Statistics for SAS
Read more
SAS Training
SAS Enterprise Guide
Read more
SAS Training
Fundamental SAS Platform Administration
Read more
SAS Training
SAS Visual Analytics
Read more

Talk to us about how we can help