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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.