The SELECT statement
retrieves and displays data. It consists of a SELECT clause and several
optional clauses that can be used within the SELECT statement. Each
clause begins with a keyword and is followed by one or more components.
The optional clauses name the input data set, subset, group, or sort
the data.
A PROC SQL step that
contains one or more SELECT statements is referred to as a PROC
SQL query. The SELECT statement is only one of several
statements that can be used with PROC SQL.