Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
PROC SQL COURSE (PART 1)

Description
​
SASCrunch Proc SQL course (part 2) is an advanced SAS programming course focusing on the SQL procedure in SAS.

It covers the different types of joins and SET operators using Proc SQL. You will also learn how to update and modify SAS tables and create integrity constraints using the SQL procedure.

Upon completion of the course, you will be capable of performing complex data manipulations and analysis using one of the most powerful and commonly used procedures in SAS.
Sign up for membership


​Highlights
  • Interactive training
  • 17 training sections
  • 27+ exercises​​
  • 7-day money back guarantee​​
Sign up for membership


​Course Outline

  • Introduction
  • Cartesian Product
  • Inner Joins
  • Table Alias
  • Inner Join with Summary Function
  • Outer Join
  • Left Outer Join
  • Combine Table Vertically
  • Overlaying Columns
  • Outer Union Set Operator
  • Creating SAS Tables
  • Creating SAS Tables using Query
  • Inserting Rows into Table
  • Updating Tables
  • Altering Columns
  • Deleting Rows and Tables
  • Integrity Constraint
  • Final Test
  • Coding Exercises
  • Coding Exercises (Answers)
Sign up for membership
Already a member? Go to member's area.