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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.