topic Re: Set by option in SAS Programming

Set by option

aaaaa34 — Sun, 24 Nov 2019 17:50:58 GMT

Hi,

What does by option do in:
data aaa;
set bbb;
by var1 var2;
run;

Re: Set by option

aaaaa34 — Sun, 24 Nov 2019 17:51:05 GMT

Re: Set by option

PaigeMiller — Sun, 24 Nov 2019 17:55:48 GMT

@aaaaa34 wrote:

What does by option do in:
data aaa;
set bbb;
by var1 var2;
run;

In this case, the BY statement with a single dataset listed in the SET statement does almost nothing. It does allow FIRST. and LAST. variables to be created and used, but your code doesn't use them, so essentially BY does nothing in your code.

Re: Set by option

Kurt_Bremser — Sun, 24 Nov 2019 17:59:28 GMT

@aaaaa34 wrote:
Hi,

What does by option do in:
data aaa;
set bbb;
by var1 var2;
run;

It forces a sort condition by var1 var2. If a deviation from the sort order is encountered during execution, the step will terminate with an ERROR.

Other than that, the by statement in your code has no effect, as neither first. or last. is used.