SAS SQL 1: Essentials - live web



Kursarrangør: SAS Institute
Sted: Nettkurs / Nettstudie
Hele landet
Type:Nettkurs og nettstudie
Undervisningstid: Ta kontakt for informasjon
Varighet: 14 timer
Pris: 10.200
Neste kurs: 16.08.2021 | Vis alle kursdatoer

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

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.