setting a table conditional on string variable

[ilikesas]

hi,

suppose I have the following table:

sector	company
A	aa
B	bb
C	cc
D	dd

I want to set the table but drop all the entries where the sector is either A or B and get the following:

sector	company
C	cc
D	dd

It is probably a simple task but when I run the following code I still can't get the answer:

data table;

set table;

if sector ne  "A" or sector ne  "B" ;

run;

Thank you!

[Ksharp · Accepted solution]

If I was right.

if sector ne  "A" and sector ne  "B" ;

if sector  not in  ('A' 'B')  ;