Specifies the output order of table rows with identical values for the BY column.
| Valid in: | SPD Server |
| Default: | No |
| Interaction: | Corresponding macro variable is SPDSBNEQ. |
does not guarantee the output order of table rows with identical values in a BY clause.
guarantees that the output order of table rows with identical values in a BY clause is the relative table position of the rows from the input table. This value is the default.
data sport.racquets(index=(string));
input
raqname $20.
@22 weight
@28 balance $2.
@32 flex
@36 gripsize
@42 string $3.
@47 price
@55 instock;
datalines;
Solo Junior 10.1 N 2 3.75 syn 50.00 6
Solo Lobber 11.3 N 10 5.5 syn 160.00 1
Solo Queensize 10.9 HH 6 5.0 syn 130.00 3
Solo Kingsize 13.1 HH 5 5.6 syn 140.00 3
;
data sport.racqbal(bynoequal=yes);
set sport.racquets;
by balance;
run;