Articles

PROC SQL - The Language of SAS
  • Print

PROC SQL - The Language of SAS training at Newtyne, Edinburgh

 

If you experience any problems with our on-line booking service, you can call us on +44 (0)131 225 6952.

Course Length:

This is a two-day course.

Course Summary:

The PROC SQL course enables you to add PROC SQL skills to your armoury of knowledge. Using ANSI-standard Structued Query Language (SQL) syntax in conjunction with the programming language of SAS to buils queries. PROC SQL can perform many similar tasks to DATA step code.

What you will be taught:

  • Introduction
    • Structured Query Language - SQL
    • PROC SQL
  • PROC SQL Language Elements
    • PROC SQL Syntax
    • Selecting Columns
    • The DESCRIBE and FEEDBACK Options
    • Create Columns
    • The CASE Expression
    • Selecting Rows
    • Special WHERE Operators
    • CALCULATED Columns
  • PROC SQL Report Presentation
    • Formats and Labels
    • Ordering Data
    • Summarizing Data
    • Classifying Data - GROUP BY
    • Selecting Summarized Data - HAVING
  • SQL Subqueries
    • Non-Correlated Subquery
    • Correlated Subquery
    • Substituting Values
    • Returning Multiple Values
  • Creating Datasets
    • Create a Data Table From The Results of a Query
    • Create a Data Table From a Definition
    • Create a Data View From The Results of a Query
    • Data Views versus Data Tables
  • Joining Datasets Horizontally
    • Inner Joins
    • Outer Joins
    • Full Outer Joins
    • The COALESCE Statement
    • Table Aliases
    • In-Line Views
  • Joining Datasets Vertically
    • Methods of Combining Data
    • Modifiers
    • Except Rule
    • Intersect Rule
    • Union Rule
    • Outer Union Rule
  • Maintaining Tables

What you should already know:

In order to gain a suitable understanding from this course, it is expected that you should have attended the, 'Foundations: The Language of SAS' course (or comparable course of study), or have completed six months of developing code in the language of SAS, including:

  • Building DATA and PROC steps
  • Character, Numeric and Date functions
  • KEEP and DROP to select variables
  • IF and WHERE statements to select observations
  • Conditional Processing with IF-THEN-ELSE
  • Combining Data Sets vertically and horizontally
  • Summarizing data with the FREQ, MEANS and TABULATE procedures

A prior understanding of SQL is not required.

 

 

If you experience any problems with our on-line booking service, you can call us on +44 (0)131 225 6952.

 

Don't Delay - Book Today!

Select a date and click on the button below to register.