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 1) is an introductory course in the SQL procedure in SAS.

It covers a wide range of topics in Proc SQL with 14 training sections and 20+ coding exercises.

Upon completion of the course, you will be able to efficiently retrieve, manipulate and analyze data using Proc SQL in SAS.
Sign up for membership


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


​Course Outline

  • Introduction
  • Retrieve Columns
  • Select Multiple Columns
  • Create New Columns
  • Case Expression
  • WHERE Clause
  • WHERE Clause with Calculated Column
  • IN Operator
  • LIKE Operator
  • ORDER BY Clause
  • Summarizing Data
  • Summary Functions
  • Counting Statistics
  • HAVING Clause
  • Subquery
  • Final Test
  • Coding Exercises
  • Coding Exercises (Answers)
Sign up for membership
Already a member? Go to member's area.