Chapter Contents |
Previous |
Next |
WHERE |
Optional statement |
Syntax | |
Details |
Syntax |
WHERE SAS-where-expression; |
Details |
The WHERE statement
loads a subset of observations into the new PC file. The SAS-where-expression must be a valid SAS WHERE statement that uses SAS variable
names (not column names) as defined in the input data set. The following example
loads only the observations in which the SAS variable COUNTRY has the value
Brazil
.
where country='Brazil';
For more information on the syntax of the SAS WHERE statement, see SAS Language Reference: Dictionary.
An editing statement, such as WHERE, must be specified after the database-description statements when you create and load a DBMS table. See LOAD for more information.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.