The WHERE Clause
A Brief Overview
The WHERE clause enables
you to subset data based on a condition that each row of the table
must satisfy. PROC SQL output includes only those rows that satisfy
the condition. The WHERE clause is used within the SELECT statement
in a PROC SQL step. The expression in the WHERE clause can be any
valid SQL expression. In the WHERE clause, you can specify any columns
from the underlying tables that are specified in the FROM clause.
The columns that are specified in the WHERE clause do not have to
be specified in the SELECT clause.
WHERE Clause Syntax
The WHERE clause must
come after the SELECT and FROM clauses.
|
Syntax, WHERE clause:
PROC SQL <options>;
SELECT column-1 <,...column-n> FROM input-tables ... |
Get SAS Certified Professional Prep Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
