Specifies whether to use an index when processing a BY statement in the SPD Engine.
Default: | YES |
Interactions: | BYSORT= LIBNAME Statement Option |
BYSORT= Data Set Option | |
Engine: | SPD Engine only |
uses an index when processing indexed variables in a BY statement.
does not use an index when processing indexed variables in a BY statement.
Note | IDXBY=NO performs an automatic sort when processing a BY statement. |
NOTE: BY ordering was produced by using an index for
table tablename.
NOTE: BY ordering was produced by performing an automatic sort
on table tablename.
libname permdata spde 'SAS-library' idxby=no;
options msglevel=i;
proc means data=permdata.customer;
var sales;
by state;
run;
NOTE: BY ordering was produced by performing an automatic sort on table PERMDATA.customer. NOTE: There were 100 observations read from the data set PERMDATA.CUSTOMER.
libname permdata spde 'SAS-library' idxby=yes;
options msglevel=i;
proc means data=permdata.customer;
var sales;
by state;
run;
The following message is written to the SAS log: NOTE: BY ordering was produced by using an index for table PERMDATA.customer. NOTE: There were 2981 observations read from the data set PERMDATA.CUSTOMER.