BYステートメントの検出時にSPD Engineで自動並べ替えを実行することを指定します。
該当要素: | DATAステップおよびPROCステップ |
デフォルト: | YES |
操作: | BYNOEQUALS=データセットオプション |
エンジン: | SPD Engineのみ |
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 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';
proc print data=growth.teens (bysort=no);
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.