Specifies whether to use an index when processing a BY statement in the SPD Engine.
Valid in: | DATA step and PROC step |
Default: | YES |
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.
options msglevel=i; proc means data=permdata.customer(IDXBY=no); by sales; by state; run;
NOTE: BY ordering was produced by performing an automatic sort on table PERMDATA.customer. NOTE: There were 2981 observations read from the data set PERMDATA.CUSTOMER.
proc means data=permdata.customer(IDXBY=yes); var sales; by state; run;
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.