SAS SQL 1: Essentials

Course Code:
SAS-SQL1M6

Duration:
2 days
9:00am to 5.00pm
Course Fees:
S$1,800 (excl of G.S.T)
2021 Course Dates
10 – 11 Aug 2021
7 – 8 Oct 2021
6 – 7 Dec 2021
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