SQL Processing with the SAS System Course Notes

by SAS Institute Inc.

No Synopsis Available.

• Format: Paperback
• ISBN: 1555446213
• ISBN13: 9781555446215
• Release Date: June 1992
• Publisher: SAS Publishing
• Length: 264 Pages
• Weight: 1.01 lbs.

Customer Reviews

SQL Processing with the SAS System

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.