[go: up one dir, main page]
Scribd
Upload
18 views2 pages

Sasr SQL 1 Essentials

The SAS(R) SQL 1: Essentials course teaches SAS programmers and business analysts how to process SAS data using SQL. It covers SQL fundamentals, joins, subqueries, set operators, and the use of macro variables, with no prior SQL knowledge required. Prerequisites include basic SAS programming skills and familiarity with SAS data sets.

Uploaded by

good.luck.mock.duck
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
18 views2 pages

Sasr SQL 1 Essentials

The SAS(R) SQL 1: Essentials course teaches SAS programmers and business analysts how to process SAS data using SQL. It covers SQL fundamentals, joins, subqueries, set operators, and the use of macro variables, with no prior SQL knowledge required. Prerequisites include basic SAS programming skills and familiarity with SAS data sets.

Uploaded by

good.luck.mock.duck
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

SAS(R) SQL 1: Essentials

Code: SQ1M6
Length: 0 days
URL: View Online

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

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.
You can gain this experience from the SAS® Programming 1: Essentials course. No knowledge of SQL is necessary.

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.

Download Whitepaper: Accelerate Your Modernization Efforts with a Cloud-Native


Strategy
Get Your Free Copy Now

Copyright ©2025 Ascendient LLC. All Rights Reserved. Generated 2025-09-12

You might also like