Brackets not eliminating records as they should

[omega1983]

Proc sql;

Create table mkt1 as

Select a.id,

       a.status_cd,

       a.sub_category,

       a.template1,

       a.balance1,

      b.State_Abbr

from datamart1       a

left join States    b

  on a.state_marker=b.state_marker

where (a.subcategory in (‘F’,’N’) and

balance1 >0  and

(a.status_cd ne ‘S’ and a.status_cd ne ‘Y’) and

(a.template1 ne ‘X’ and a.template1 ne ‘G’));

quit;

I ran this code above.  In checking the data, it did not eliminate the status_cd of 'S' or 'Y'.  I then took out the brackets for the status_cd and reran it.  It is running forever now and will not stop.  I want to eliminate the status_cd and the template1 that I have specified. The brackets are balanced so how come they fo not eliminate?

[Reeza · Accepted solution]

I think you're looking for

a.status_cd not in ("S", "Y") and a.template1 not in ("X", "G") instead of all the ands

[omega1983]

Thanks. It worked like a charm