topic proc sql in SAS Programming

proc sql

Anita_n — Wed, 07 Aug 2019 07:29:38 GMT

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 — Wed, 07 Aug 2019 08:42:48 GMT

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 — Wed, 07 Aug 2019 11:11:22 GMT

Okay, thank you