This course is designed to apply knowledge gained from SAS SQL 1: Essentials to a comprehensive case study project. It includes a review of SAS SQL 1 material along with the case study where you will use PROC SQL to access, explore, prepare, analyze and report on real data. This course builds on the concepts that are presented in the SAS SQL 1 and is not recommended if you have not taken the prerequisite.
Learn How To
Apply your skills from SAS SQL 1
Query and subset data
Summarize and present data
Combine tables using joins and set operators
Create and modify tables and views
Who Should Attend
SAS programmers and business analysts
Prerequisites
SAS SQL 1: Essentials In addition, before attending this class, you should be able to do the following: Submit SAS programs on your operating system Create and access SAS data sets Use arithmetic, comparison, and logical operators Invoke SAS procedures You can gain this experience from the SAS Programming 1: Essentials course