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)