— SAS-SQL1M6

SAS-SQL1M6 | SAS SQL 1: Essentials

SAS-SQL1M6

No Exam

2 Day(s)

Instructor-Led Training

SGD $1980

Course Schedules

17 Nov 2022 – 18 Nov 2022
01 Dec 2022 – 02 Dec 2022
06 Oct 2022 – 07 Oct 2022

TELL YOUR FRIENDS

Course OVERVIEW

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

WHO IS THE COURSE FOR?

SAS programmers and business analysts

ATTAINABLE SKILLS

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

LEARNING PATHWAY

Module 1: Essentials

Module 2: PROC SQL Fundamentals

Module 3: SQL Joins

Module 4: Subqueries

Module 5: Set Operators

Module 6: Using and Creating Macro Variables in SQL

Module 7: Accessing DBMS Data with SAS/ACCESS

FULL COURSE OUTLINE 👉

Related Courses

You might also be interested in these courses

sas-banner-single
SAS-EG182 | SAS Enterprise Guide 1: Querying & Reporting
sas-banner-single
SAS-MC1V2 | SAS Macro Language 1: Essentials
sas-banner-single
SAS-DIDP01 | Self - Service Data Preparation in SAS Viya
sas-banner-single
ROSI35 | SAS Viya and R Integration for Machine Learning
sas-banner-single
PGVY2 | Programming for SAS Viya
sas-banner-single
POSI35 | SAS Viya and Python Integration for Machine Learning

Have A Question?

WE'RE Here To Assist You 😊

Alternatively, you may contact us via live chat on the bottom right of your browser.