• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

Fundamental SAS SQL

30 Hours
Online Instructor-led Training
GBP 999 (GBP 2000)
Save 50% Offer ends on 30-Jun-2024
Fundamental SAS SQL course and certification
318 Learners

About this Course

This course covers Proc SQL in detail, concentrating on the use of SQL for existing SAS Programmers. Traditional SAS DATA steps and Proc steps are compared with using Proc SQL and efficiency issues are discussed.

------------------------------------------------------
Target Audience

SAS Programmers who wish to know the benefits and role of SQL Programming within the SAS System.
------------------------------------------------------

 

Fundamental SAS SQL

Course Details & Curriculum

SQLF 1 lntroduction to Proc SQL

  • Introduction to Proc SQL
  • Concepts
  • Features of Proc SQL
  • Course Overview

SQLF 2 Selecting Data From a Single Table

  • Clauses in the Select Statement
  • Simple Examples
  • SELECT Clause
  • FROM Clause
  • WHERE Clause
  • ORDER BY Clause
  • GROUP BY Clause
  • HAVING Clause
  • SAS Data Set Options
  • Other Topics
  • Further Examples (Optional)

SQLF 3 Joining Data From Two Tables

  • The FROM Clause Revisited
  • Inner Joins
  • Outer Joins
  • Equivalent DATA Steps

SQLF 4 Other SQL Statements

  • Creating Tables
  • SQL Views
  • Deleting Tables and Views
  • Changing Data in Tables
  • Changing the Structure of Tables
  • RESET Statement

SQLF 5 Using Macro Variables

  • What are Macro Variables?
  • Selecting INTO
  • Lists Using SEPARATED BY
  • Macro Variables Set by Proc SQL
------------------------------------------------------

Didn't find what you are looking for?  Contact Us

course.php