SAS(R) SQL 1: Essentials

Course code: SQ1M6

This course teaches you how to process SAS data using Structured Query Language (SQL).
1 080 EUR

1 307 EUR including VAT

Selection of dates
Do you have a question?
+420 731 175 867

and certified lecturers

recognized certifications

Wide range of technical
and soft skills courses

Great customer

Making courses
exactly to measure your needs

Course dates

Starting date: Upon request

Type: E-learning

Course duration: 7 hours

Language: en

Price without VAT: 1 080 EUR


Starting date: Upon request

Type: Upon request

Course duration: 17h 30min

Language: en

Price without VAT: 1 800 EUR


Type Course
Language Price without VAT
Upon request E-learning 7 hours en 1 080 EUR Register
Upon request Upon request 17h 30min en 1 800 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.


Target group

SAS programmers and business analysts

Course structure


  • Setting up for this course.
  • Overview of SAS Foundation.
  • Course logistics.
  • Course data files.
  • Introducing the Structured Query Language.
  • Overview of the SQL procedure.
  • Exploring tables.
  • Specifying columns.

PROC SQL Fundamentals

  • Subsetting data.
  • Presenting data.
  • Summarizing data.
  • Creating and managing tables.
  • Using DICTIONARY tables.

SQL Joins

  • Introduction to SQL joins.
  • Inner joins.
  • Outer joins.
  • Complex SQL joins.


  • Noncorrelated subqueries.
  • Correlated subqueries.
  • In-line views.
  • Creating views with the SQL procedure.
  • Subqueries in the SELECT clause.
  • Remerging summary statistics.

Set Operators

  • Introduction to set operators.
  • The INTERSECT operator.
  • The EXCEPT operator.
  • The UNION operator.
  • The OUTER UNION operator.

Using and Creating Macro Variables in SQL

  • Interfacing PROC SQL with the macro language.
  • Creating data-driven macro variables with a query.
  • Using macro variables in SQL.

Accessing DBMS Data with SAS/ACCESS

  • Overview of SAS/ACCESS technology.
  • SQL pass-through facility.
  • SAS/ACCESS LIBNAME statement.
  • PROC FedSQL.


Before attending this class, you should be able to do the following:
  • Submit SAS programs on your operating system.
  • Create and access SAS data sets.
  • Use arithmetic, comparison, and logical operators.
  • Invoke SAS procedures.
  • Do you need advice or a tailor-made course?


    product support

    ComGate payment gateway MasterCard Logo Visa logo