Brackets not eliminating records as they should

omega1983 — Mon, 13 May 2013 21:01:11 GMT

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?

Re: Brackets not eliminating records as they should

Reeza — Mon, 13 May 2013 21:06:37 GMT

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

Re: Brackets not eliminating records as they should

omega1983 — Tue, 14 May 2013 18:47:56 GMT

Thanks. It worked like a charm

topic Brackets not eliminating records as they should in SAS Procedures

Brackets not eliminating records as they should

Re: Brackets not eliminating records as they should

Re: Brackets not eliminating records as they should