PROC SQL reference information from the Base SAS Procedures Guide and SAS SQL system options from the SAS Language Reference: Dictionary have been moved to this book, SAS SQL Procedure User’s Guide. This enables our customers to access PROC SQL information in one location. The following are new features and enhancements:
The following reduce PUT options and system options have been modified to optimize the PUT function:
The database connection that is established with the LIBNAME statement can be reused in the CONNECT statement. The keyword USING has been added to implement this feature.
The following PROC SQL statement options have been added to help control execution and output of results:
The following macro variable specifications have been added to the syntax for the INTO clause of the SELECT statement:
The VIEW_SOURCES dictionary table view has been added.
The SYS_SQLSETLIMIT macro variable has been added for use with PROC SQL to improve database processing.
Where applicable, all of the LISTING output examples have been updated to show the new ODS HTML output. The new SAS 9.3 output defaults apply only to the SAS windowing environment under Microsoft Windows and UNIX.