SAS SQL 1: Essentials

Duration: 16 hours

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, including complex joins and merges
  • Create and modify table views and indexes
  • Replace multiple DATA and PROC steps with one SQL query.
  • Who should attend: SAS programmers and business analysts.

    Prerequisites:

    Before attending this class, you should be able to:

    • 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.
    This course addresses Base SAS software.
    This course is appropriate for students who are using SAS 9 software.