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?
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
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
Thanks. It worked like a charm
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.