Website is currently under going upgrading works. Some features may not be available. Should you require any assistance, do contact us via email at enquiries@avantustraining.com.
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

TELL YOUR FRIENDS

Exam Code

Course Duration

3 Day(s)

Delivery Mode

Instructor-Led Training

Course Price

from $1980
*Course Pricing Subjected to Terms & Conditions.

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-CPML22 | Machine Learning Using SAS® Viya
sas-banner-single
SAS-YVA175 | SAS® Visual Analytics 1 for SAS® 9: Basics
sas-banner-single
SAS-JMDE16 | JMP Software: Custom Design of Experiments
sas-banner-single
SAS-PG2V2 | SAS® Programming 2: Data Manipulation Techniques
sas-banner-single
SAS-POSI35 | SAS® Viya® and Python Integration for Machine Learning
sas-banner-single
SAS-JCSA16 | JMP® Software: A Case Study Approach to Data Exploration

Have A Question?

WE'RE Here To Assist You 😊

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