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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.