Chapter Contents
Previous
Next
|
Chapter Contents |
Previous |
Next |
| WHERE |
| Optional statement | |
| Applies to: | New and existing database |
| Syntax | |
| Details |
Syntax |
| WHERE SAS-where-expression; |
| Details |
The WHERE statement indicates you want to subset your input data. The SAS-where-expression must be a valid SAS WHERE statement. Here is a simple example of a WHERE statement.
where custname='JONES, APRIL';
This statement loads only those observations with JONES, APRIL in the SAS variable CUSTNAME.
Use the SAS variable names in the WHERE statement, not the SYSTEM 2000 component names. For more details on the syntax of the SAS WHERE statement, see SAS Language Reference: Dictionary.
|
Chapter Contents |
Previous |
Next |
 Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.