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 1Query and subset dataSummarize and present dataCombine tables using joins and set operatorsCreate and modify tables and viewsWho 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
SAS Products Covered
Base SAS
Course Outline
Data DiscoverySAS SQL 1 ReviewAccess and Explore DataExploring tablesExploring columnsUsing DICTONARY tablesPrepare DataSubsetting dataPresenting data Summarizing data with functions Creating and managing tables The OUTER UNION operatorInner join Creating viewsAnalyze and Report on Data Using functions to report on data