Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

SAS(R) SQL 1: Essentials

  • Tuition USD $1,300
  • Reviews star_rate star_rate star_rate star_rate star_half 329 Ratings
  • Course Code SQ1M6
  • Duration 2 days
  • Available Formats Classroom, Virtual

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

Skills Gained

  • 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 Can Benefit

  • 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.

Course Details

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.

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

Really nice and helpful staff! Office has well thought out interior design and plenty of snacks and drinks and coffee.

Facilities were very clean, coffee was nice to have, snack selection was refreshing

Informative class with great instructure who was able to walk through the course material, answer all questions, and give great examples.

A must take course if you want to be an AWS cloud architect. It touches almost all the essential services in AWS

Ken is a great AWS Architecting instructor. He know's AWS products very well.

26 options found

undo
  • Jul 16, 2020 Jul 17, 2020 (2 days)
    Location
    Bloomfield, CT
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • GTR Jul 20, 2020 Jul 24, 2020 (5 days)
    Location
    Virtual
    Language
    English
    Time
    1:00 PM 4:30 PM EST
    Enroll
    Enroll
  • Jul 21, 2020 Jul 22, 2020 (2 days)
    Location
    Arlington, VA
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • GTR Jul 21, 2020 Jul 22, 2020 (2 days)
    Location
    Virtual
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Jul 27, 2020 Jul 28, 2020 (2 days)
    Location
    Waltham, MA
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Aug 10, 2020 Aug 11, 2020 (2 days)
    Location
    New York, NY
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Aug 11, 2020 Aug 12, 2020 (2 days)
    Location
    Virtual
    Language
    English
    Time
    12 PM 8:00 PM EST
    Enroll
    Enroll
  • Aug 11, 2020 Aug 12, 2020 (2 days)
    Location
    Sacramento, CA
    Language
    English
    Time
    9:00 AM 5:00 PM PST
    Enroll
    Enroll
  • Aug 31, 2020 Sep 1, 2020 (2 days)
    Location
    Cary, NC
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Aug 31, 2020 Sep 1, 2020 (2 days)
    Location
    Virtual
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Sep 14, 2020 Sep 18, 2020 (5 days)
    Location
    Virtual
    Language
    English
    Time
    1:00 PM 4:30 PM EST
    Enroll
    Enroll
  • Sep 21, 2020 Sep 23, 2020 (3 days)
    Location
    Virtual
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Sep 24, 2020 Sep 25, 2020 (2 days)
    Location
    Chicago, IL
    Language
    English
    Time
    9:00 AM 5:00 PM
    Enroll
    Enroll
  • Oct 8, 2020 Oct 9, 2020 (2 days)
    Location
    Charlotte, NC
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
  • Oct 8, 2020 Oct 9, 2020 (2 days)
    Location
    Virtual
    Language
    English
    Time
    9:00 AM 5:00 PM EST
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward