SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

Download or read book SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition written by SAS Institute and published by . This book was released on 2015 with total page 482 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.