Chapter Contents

Previous

Next
WHERE

WHERE



Loads a subset of data into the new PC file.

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.