PROC SQL - The Language of SAS
Simply fill in the form below to sign up for our Newsletter:
captcha 
Sign Up for our Newsletter

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

 

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 Structured Query Language (SQL) syntax in conjunction with the programming language of SAS to build 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 the dates below do not suit please contact us on +44 (0)131 225 6952 as alternative dates can be arranged.

 


 

Don't Delay - Book Today!

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