setting a table conditional on string variable

ilikesas — Fri, 15 May 2015 13:32:12 GMT

hi,

suppose I have the following table:

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!

Re: setting a table conditional on string variable

Ksharp — Fri, 15 May 2015 15:29:25 GMT

If I was right.

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

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