Apologies All, It seems I was quite unclear in my questions. My current query is: proc sql;
create table test as
select
a.*,
b.field1,
b.field2,
b.field3
from tableA as a
LEFT JOIN
tableB as b ON a.CustomerNum = b.CustomerNum
where
b.field1 IN (123,456,789,010,111,212,131,415); quit;
I'd like to change the way I'm manually adding the numbers in the where clause to something less manual as currently I copied and pasted to test the logic of my query. Hoping the above makes more sense that my initial query cc:@PaigeMiller @ballardw
... View more
