SAS SQL 1: Essentials

Course Code:
SAS-SQ1M6

Duration:
2 days
9:00am to 5.00pm
Course Fees:
S$1,800 (excl of G.S.T)
2020 Course Dates
23 – 24 Jul 2020
11 – 12 Aug 2020
29 – 30 Aug 2020
7 – 8 Sep 2020
9 – 10 Sep 2020
8 – 9 Oct 2020
1 – 2 Dec 2020
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.

Course Overview

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

Program Objectives

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

Course Outline

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

Click Here for full course Outline

Take The Next Step

It Takes Less Than 5 Min