As @Reeza suggested you could use pass through, syntax is more or less as follows (but do check documentation for the details):
proc sql;
/* start connection to some database <engine> e.g. Teradata, Oracle, Postgers */
connect to <ENGINE> as DB (user="user" password="password" database="database" server="123.123.123.123");
create table WORK.LOCAL AS /* create local table */
(
select * from connection to DB /* with pass through to database with databale native SQL */
(
select A.id, A.x, B.y
from Exteranal1 A
join External2 B
on A.id = B.id
)
);
disconnect from BD;
quit;
Bart
... View more