SAS-SQL1M6 | SAS SQL 1: Essentials

SAS-SQL1M6

-

2 Day(s)

Instructor-Led Training

from SGD $1980

Course Schedules

09 Jan 2023 - 10 Jan 2023
23 Feb 2023 - 24 Feb 2023
16 Mar 2023 - 17 Mar 2023
25 May 2023 - 26 May 2023
01 Jun 2023 - 02 Jun 2023
06 Oct 2022 – 07 Oct 2022
17 Nov 2022 – 18 Nov 2022
01 Dec 2022 – 02 Dec 2022

TELL YOUR FRIENDS

Exam Code

Course Duration

2 Day(s)

Delivery Mode

Instructor-Led Training

Course Price

from $1980

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- YVA275 | SAS Visual Analytics 2 for SAS 9: Advanced
sas-banner-single
SAS - YBA175 | SAS Visual Analytics 1 for SAS 9: Basics
sas-banner-single
SAS-SPAFM7 | SAS Platform Administration: Fast Track
sas-banner-single
SAS-PG2V2 | SAS Programming 2: Data Manipulation Techniques
sas-banner-single
SAS-DMTX41 | Text Analytics Using SAS Text Miner
sas-banner-single
SVTA35/SVTA01 | SAS Visual Text Analytics on SAS Viya

Have A Question?

WE'RE Here To Assist You 😊

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

Search For A Course..

You may be interested in these