SQL equivalent

Obsidian | Level 7

DATA TABLE1;
 SET TABLE2
     TABLE3
     TABLE4;
 KEEP OBS2 OBS4;
RUN;

1 REPLY 1

Barite | Level 11

Re: SQL equivalent

Posted 10-22-2015 12:34 PM (976 views) | In reply to G_I_Jeff

Union All will include duplicates. Union will remove duplicates:

proc sql;
create table table1 as
select obs2,obs4
from table2
union
select obs2,obs4
from table3
union
select obs2,obs4
from table4;