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.

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

​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)