Directs SAS to use a specific index to match the conditions of a WHERE expression.
Valid in: | DATA step and PROC steps |
Category: | User Control of SAS Index Usage |
Restrictions: | Use with input data sets only. |
Mutually exclusive with IDXWHERE= data set option |
specifies the name (up to 32 characters) of a simple or composite index for the SAS data set. SAS does not attempt to determine whether the specified index is the best one or whether a sequential search might be more resource efficient.
Interaction | The specification is not a permanent attribute of the data set and is valid only for the current use of the data set. |
Tip | To request that IDXNAME= usage be noted in the SAS log, specify the system option MSGLEVEL=I. |
data mydata.empnew; set mydata.employee (idxname=empnum); where empnum < 2000; run;