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

Output 1.2 Sample DATA Step Output

This example shows that PROC SQL can achieve the same results as Base SAS software

but often with fewer and shorter statements. The SELECT statement that is shown in this

example performs summation, grouping, sorting, and row selection. It also displays the

query's results without the PRINT procedure.

PROC SQL executes without using the RUN statement. After you invoke PROC SQL

you can submit additional SQL procedure statements without submitting the PROC

statement again. Use the QUIT statement to terminate the procedure.

Notes about the Example Tables

For all examples, the following global statement is in effect: ...