It works with one condition and I'm unable to mame it work for more than one condition.
Following code is working correctly:
data want;
set sashelp.class;
where not (age in (11,12,13));
run;
where as the below code is not working if I tweak the above code with more than one condition:
6 data want2;
27 set sashelp.class;
28 where not (age in (11,12,13)
29 and weight=112);
30 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
WHERE age not in (11, 12, 13) or (weight not = 112);
data want2;
set sashelp.class;
where not (age in (11,12,13)
and weight=112);
run;
Log:
... View more