From: debanjali on
proc sql;
connect to oracle (user=&userP orapw=&pswdP preserve path = "@XXXXXX"
buffsize= 32767);
create table TEMP as
select * from connection to oracle
(
SELECT a.Z as pid,
b.LS as pgm,
c.W as WO,
FROM X1 a,
X2 b,
X3 c

where (a.Z= b.Z)
and (b.Z= c.Z)
);
quit;
can someone pls help me to find the missing expression here?
From: Patrick on
Get rid of the comma at the end of this line:
c.W as WO,