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

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Book Job Ready SQL
Journey Microsoft Excel
Rating 3.6 of 10 users Rating 3.6 of 10 users (10)