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.When a PROC SQL statement is executed, PROC SQL continues to run until a QUIT statement, a DATA step, or another SAS procedure is ... 214 Chapter 7 SQL Procedure ac Threaded Processing Using PROC SQL Syntax: SQL Procedure.
|Title||:||SAS 9.4 SQL Procedure User's Guide|
|Publisher||:||SAS Institute - 2013-07-10|