Hi! I've a two server SAS infrastructure and I want to join two tables from different servers. I've Server_A with an example table named PAYLIST_A inside the folder /data/PROCLIB and I've Server_B with an example table named PAYLIST_B inside the folder /data/ORIOLIB If I try to join the tables using the query builder, what I get is: %_eg_conditional_dropds(WORK.QUERY_FOR_PAYLIST);
PROC SQL;
CREATE TABLE WORK.QUERY_FOR_PAYLIST AS
SELECT t1.IdNum,
t1.Gender,
t1.Jobcode,
t1.Salary,
t1.Birth,
t1.Hired,
t2.IdNum AS IdNum1,
t2.Gender AS Gender1,
t2.Jobcode AS Jobcode1,
t2.Salary AS Salary1,
t2.Birth AS Birth1,
t2.Hired AS Hired1
FROM PROCLIB.PAYLIST_A t1
INNER JOIN WORK.PAYLIST_B t2 ON (t1.IdNum = t2.IdNum);
QUIT; So what Query Builder does, is to download PAYLIST_B from server B, and save it in server A WORK, but if I try to run this code without previously Query Builder download the PAYLIST_B table, it does not work. It simply says ERROR: File WORK.PAYLIST_B t2 does not exist.
How can I join to tables in different servers in a program without using the query builder?
... View more
