SQL Processing with the SAS (R) System Course Notes

Rating:
Summary: SQL Processing with the SAS System
Review: This is the course guide that accompanies the SAS Institute instructor-based training course SQL Processing with the SAS System.

The manual is an excellent desk reference guide and provides in-depth explanation and exercises with accompanying solutions that can be utilized outside the course itself.

The course guide has 5 sections and an appendix. All sections exercises and chapter summaries.

Section 1 Introduction includes: structured query language, accessing data and SAS functions.

Section 2 Basic Queries has: overview of PROC SQL, specifying columns, specifying rows, presenting data, summarizing data, subqueries.

Section 3 Combining Tables includes: joins, complex joins and set operators.

Section 4 Creating and Modifying Tables and Views has: creating tables, creating views, creating indexes and maintaining tables.

Section 5 Additional SQL Features includes: setting PROC SQL options, dictionary tables and views, interfacing PROC SQL with the macro language, and program testing and performance.