Specifies whether SAS uses an index search or a sequential search to match the conditions of a WHERE expression.
Valid in: | DATA and PROC steps |
Category: | User Control of SAS Index Usage |
Restrictions: | Use with input data sets only. |
Mutually exclusive with IDXNAME= data set option. | |
Supports: | SAS data set |
tells SAS to choose the best index to optimize a WHERE expression, and to disregard the possibility that a sequential search of the data set might be more resource-efficient.
tells SAS to ignore all indexes and satisfy the conditions of a WHERE expression with a sequential search of the data set.
data mydata.empnew; set mydata.employee (idxwhere=yes); where empnum < 2000;
data mydata.empnew; set mydata.employee (idxwhere=no); where empnum < 2000;