Hi @Patrick , I am confused at another point. I tried to wrote the code according to your guideline, just please ignore the fedsql part.
proc sql;
CREATE TABLE PUBLIC.table1 AS
SELECT
...
FROM
from sqlsource1
...
quit;
proc casutil INCASLIB = 'public';
DROPTABLE CASDATA = 'table1 ';
quit;
proc casutil INCASLIB= 'public' OUTCASLIB = 'public';
PROMOTE CASDATA = 'table1 ';
run;
proc casutil;
SAVE INCASLIB="public" CASDATA = "table1 " REPLACE;
quit;
In this way, I create and drop the table. Then in promote step CAS couldn't found a table named table1, no wonder. Which part is wrong?
... View more
