BYステートメントの検出時にSPD Engineで自動並べ替えを実行することを指定します。
デフォルト: | YES |
操作: | BYNOEQUALS=データセットオプション |
エンジン: | 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 growth spde 'SAS-library';
data growth.teens;
input Name $ Sex $ Age Height Weight;
datalines;
Alfred M 14 69.0 112.5
Carol F 14 62.8 102.5
James M 13 57.3 83.0
Janet F 15 62.5 112.5
Judy F 14 64.3 90.0
Philip M 16 72.0 150.0
William M 15 66.5 112.0
;
proc print data=growth.teens; by sex;
run;
BYSORT=YESがデフォルトのため、PROC SORTを使用してデータを並べ替えていなくても、エラーは発生しません。出力は次のとおりです。libname growth spde 'SAS-library' bysort=no;
proc print data=growth.teens;
by sex;
run;
ERROR:Data set GROWTH.TEENS is not sorted in ascending sequence.The current by-group has Sex = M and the next by-group has Sex = F. NOTE:The SAS System stopped processing this step because of errors.