SAS® SQL 1: Essentials
START FREE TRIAL
Available in:
Education Category Image


  
SAS® SQL 1: Essentials
Duration: 14 hours
SQL1 : SQ1M6
This course teaches you how to process SAS data using Structured Query Language (SQL).
Learn How To
  • Query and subset data.
  • Summarize and present data.
  • Combine tables using joins and set operators.
  • Create and modify tables and views.
  • Create data-driven macro variables using a query.
  • Access DBMS data with SAS/ACCESS technology.
    • Who Should Attend
    SAS programmers and business analysts
    Prerequisites
    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.;You can gain this experience from the SAS Programming 1: Essentials course. No knowledge of SQL is necessary.
    • SAS Products Covered
    Base SAS
    Course Outline
    Essentials
  • 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.
    • Subqueries
  • 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.

    • Live Instructor Dates SOLD SEPARATELY
    DATES ▼ LOCATION ▲
    ▼    		 TIME ▲
    ▼    		LANGUAGEEVENT FEE
    09-13 JUN 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    10-11 JUL 2025Live Web, US9:00 AM-5:00 PM EDTEnglish1,600 USD
    11-15 AUG 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    08-11 SEP 2025Live Web, US10:30 AM-2:30 PM EDTSpanish1,600 USD
    15-19 SEP 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    02-03 OCT 2025Live Web, US9:00 AM-5:00 PM EDTEnglish1,600 USD
    13-17 OCT 2025Live Web, US1:00 PM-4:30 PM EDTEnglish1,600 USD
    17-21 NOV 2025Live Web, US1:00 PM-4:30 PM ESTEnglish1,600 USD
    08-12 DEC 2025Live Web, US1:00 PM-4:30 PM ESTEnglish1,600 USD
    sas certification badge

    This course helps prepare you to earn the following SAS Credentials:


    SAS Certification Manager

    SAS partners with Pearson VUE to provide you with the best possible certification experience.

    Login


    Certification Resources

    certification home icon

    Certification Home
    webinars icon

    Webinars
    exam preparation icon

    Exam Preparation

    THIS COURSE IS PART OF

    SAS Advanced Programming Professional Subscription