SAS Certified Advanced Programmer for SAS 9

SAS SQL 1: Essentials

Virtual Instructor-Led Training

Onsite Training

AI & Data

SAS Programming, BASE

<ul><li>Overview of SAS Foundation</li><li>Course logistics</li><li>Course data files</li><li>Introducing the SQL</li></ul>

Introduction

<ul><li>Overview of the SQL procedure</li><li>Specifying columns</li><li>Specifying rows</li></ul>

Basic Queries

<ul><li>Presenting data</li><li>Summarizing data</li></ul>

Displaying Query Results

<ul><li>Introduction to SQL joins</li><li>Inner joins</li><li>Outer joins</li><li>Complex SQL joins</li></ul>

SQL Joins

<ul><li>Noncorrelated subqueries</li><li>In-line views</li></ul>

Subqueries

<ul><li>Introduction to set operators</li><li>The UNION operator</li><li>The OUTER UNION operator</li><li>The EXCEPT operator</li><li>The INTERSECT operator</li></ul>

Set Operators

<ul><li>Creating tables with the SQL procedure</li><li>Creating views with the SQL procedure</li></ul>

Creating Tables and Views

<ul><li>Dictionary tables and views</li><li>Using SQL procedure options</li><li>Interfacing PROC SQL with the macro language</li></ul>

Advanced PROC SQL Features

<ul><li>SAS resources beyond this course</li></ul>

Learning More

SAS Advanced Programming for SAS 9

Organization Development

courseBanner

Course Banner

courseOverview

Course Overview section

courseAnnouncement

Additional information.

courseDetails

What you will learn

targetAudience

Who should attend

courseOutline

Course Outline

courseFAQ

Coursepromobanner

Course Promobanner Section

courseRelatedTargets

Course Related Targets

courseTicker

Course Ticker

preRequisites

Prerequisites

courseTestimonials

Customer Testimonials

courseLocations

Find More Locations by NetCom Learning For This Training

For Your convenience we are offering This course at more locations. Expand your training options and accelerate your learning journey with NetCom.

Learn the essentials of how to process SAS data using Structured Query Language (SQL).