Help using Base SAS procedures

Brackets not eliminating records as they should

Accepted Solution Solved
Reply
Contributor
Posts: 59
Accepted Solution

Brackets not eliminating records as they should

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?


Accepted Solutions
Solution
‎05-13-2013 05:06 PM
Super User
Posts: 19,805

Re: Brackets not eliminating records as they should

Posted in reply to omega1983

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

View solution in original post


All Replies
Solution
‎05-13-2013 05:06 PM
Super User
Posts: 19,805

Re: Brackets not eliminating records as they should

Posted in reply to omega1983

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

Contributor
Posts: 59

Re: Brackets not eliminating records as they should

Thanks. It worked like a charm

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 125 views
  • 0 likes
  • 2 in conversation