Hello! While doing my project I do see two ways of dealing with my SAS objects. Seems 2nd way is preferred(seems it works faster) but can you say, am I correct with it or not? proc sql;
create table t1 (id int, typ char(3), qty int);
insert into t1
values (1, 'aas', 50)
values (2, 'aaf', 15)
values (3, 'aaa', 50)
values (4, 'abd', 5)
values (5, 'asa', 25)
values (6, 'afa', 5)
values (7, 'aba', 15);
quit;
data d1;
input qty2;
datalines;
5
15
;
run; first option: proc sql; create table want as select * from t1 where qty in (select qty2 from d1); quit; second option: proc sql noprint; select qty2 into: qty3 separated by "," from d1; quit;
proc sql; create table want as select * from t1 where qty in (&qty3); quit; THX!
... View more
