Home About Courses Schedule Services Webinars Contact Search

SAS SQL Procedure Workshop

SEE SCHEDULE

Duration: 2 Days

Method: Instructor led, Hands-on workshops

Price: $1125.00

Course Code: SA1004


Audience

Application Programmers, Designers interested in gaining an understanding of SQL and System Programmers.

Description

This workshop uses the 'Hands-On' approach to teach the participants the essential concepts of Structured Query Language (SQL) using the SAS procedure PROC SQL.

Objectives

Upon successful completion of this course, the student will be able to:

  • Understand Relation Concepts
  • Use PROC SQL.
  • Use SQL in all aspects of data retrieval.

Topics

  • I. Relational overview
  • II. PROC SQL overview
  • III. SELECT
  • IV. FROM
  • V. WHERE
  • VI. SAS OUTPUT
  • VII. Using SAS Datasets
  • VIII. Simple SQL Queries
  • IX. CASE
  • X. SAS Functions
  • XI. Subquery
  • XII. JOIN
  • XIII. UNIONs
  • XIV. Creating new SAS Data