SPD EngineでのBYステートメント処理時にインデックスを使用するかどうかを指定します。
デフォルト: | YES |
操作: | BYSORT= LIBNAMEステートメントオプション |
BYSORT=データセットオプション | |
エンジン: | SPD Engineのみ |
注:BY ordering was produced by using an index for table tablename.
注: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.注: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;
次のメッセージがSASログに書き込まれます。注:BY ordering was produced by using an index for table PERMDATA.customer.注:There were 2981 observations read from the data set PERMDATA.CUSTOMER.