SAS 9.4 SQL Procedure User's Guide, Third Edition

  • 5h 55m
  • SAS Institute
  • SAS Institute
  • 2015

Describes the basics of using the SQL procedure and provides comprehensive reference information. The usage information includes retrieving data from single and multiple tables; selecting specific data from tables; subsetting, ordering, and summarizing data; updating tables; combining tables to create new tables and useful reports; performing queries on database management system (DBMS) tables; using PROC SQL with the SAS macro facility; and debugging and optimizing PROC SQL code. The reference information includes statements, dictionary components, and system options.

In this Book

  • About This Book
  • What's New in the SAS 9.4 SQL Procedure
  • Introduction to the SQL Procedure
  • Retrieving Data from a Single Table
  • Retrieving Data from Multiple Tables
  • Creating and Updating Tables and Views
  • Programming with the SQL Procedure
  • Practical Problem-Solving with PROC SQL
  • SQL Procedure
  • SQL Procedure Components
  • Recommended Reading
SHOW MORE
FREE ACCESS