proc sql

[Anita_n]

I am tring to use proc sql to select a set of data from a table.

I wish to do many combinations using where and or

for example

proc sql;

create table test as select distinct * from have

where not((x="an" and y="at") or (x="be" and y="as") or (etc.: further combinations));

quit;

it doesn't work with the or operator. Does it mean or doesn't work in proc sql or am I making

a mistake some where.

I will be grateful for any help

[Shmuel]

Lat's suppose that condition (x="an" and y="at") exists, then any other condition do not exist,

therefore, while checking for not(condition1 or condition2 ...) will always be false and where will never exist.

Try where not condition1 and not condition2 and not ... 

[Anita_n]

Okay, thank you