Training The Digital Workforce of Tomorrow.
SAS-SQ1M6 | SAS® SQL 1: Essentials

SAS-SQ1M6

-

3 Day(s)

Instructor-Led Training

from SGD $1980*

Course Schedules

08 Jan 2024 - 10 Jan 2024
06 Feb 2024 - 08 Feb 2024
18 Mar 2024 - 20 Mar 2024
06, 07, 10 June 2024

Enroll/ Enquire Now

*Course Pricing Subjected to Terms & Conditions.

Course Overview

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

Who Should Enrol?

SAS programmers and business analysts

Course Outcome

• 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-DIDP1H | Self-Service Data Preparation in SAS® Viya®
sas-banner-single
SAS-MC2 | SAS® Macro Language 2: Advanced Techniques
sas-banner-single
SAS-YVA175 | SAS® Visual Analytics 1 for SAS® 9: Basics
sas-banner-single
SAS-CPML22 | Machine Learning Using SAS® Viya
sas-banner-single
SAS-ST242 | Statistics 2: ANOVA and Regression
sas-banner-single
SAS-SPAFM7 | SAS Platform Administration: Fast Track