DBLOAD Procedure Reference |
Subsets input data
Applies to: |
New and existing databases
|
WHERE SAS-where-expression;
|
The WHERE statement
specifies how you want to subset your input data.
SAS-where-expression must be a valid WHERE statement in
SAS.
Note: You must use SAS variable names in the WHERE statement;
do not use the SYSTEM 2000 component names. ![[cautionend]](../../../../common/61925/HTML/default/images/cautend.gif)
For example, the following statement loads only those observations that
contain JONES and APRIL in the SAS variable CUSTNAME:
where custname='JONES, APRIL';
For information about the WHERE
statement in SAS, see
SAS Language Reference: Dictionary.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.