the select * is replaced with below query. Also caslib tables are unique . Sample code: libname test oracle path="********" schema="*****" authdomain="Oracle.*****" encoding='UTF8'; options casdatalimit=ALL; PROC SQL ; CREATE TABLE output1 AS SELECT t1.column1, t2.column1, t2.column2, t2.column3, t2.column4, t2.column5, t2.column6, t2.column7, t2.column8, t2.column9, t2.column11 AS column1name, t2.column12, t2.column13, t2.column14, t2.column15, t3.column1, t2.column1, /**/ (SUM(t1.column1)) AS columnname FROM test.table1 t1, /* this is a full load oracle table with ~80gb size*/ caslib.table2 t3, caslib.table2 t4, caslib.table2 t5, caslib.table2 t2, caslib.table2 t6 WHERE (t1.column1 = t3.column1 AND t1.column2 = t4.column2 AND t1.column3 = t5.column3 AND t5.column4 = t2.column4 AND t1.column5 = t6.column5) AND (t1.column5 = t1.column6 AND t1.column7= 99991231 AND t2.column7 NOT IN ('*******','********') AND t4.column8= '*****' AND t4.column9= '******' AND t6.column4= '*****') GROUP BY t1.column1, t3.column1, t4.column1, t4.column2, t4.column3, t4.column4, t4.column5, t4.column6, t4.column7, t4.column8, t4.column2, t4.column2, t2.column2 ORDER BY column1; quit;
... View more