hello @ChrisNZ Sorry, my bad. But I could figure it out myself. So below is the sample query. So when I run this on Teradata, it runs in 40 sec whereas on SAS it took 8 minutes. From TD logs, I see that the only SELECT from proc sql runs on TD , SAS then brings back the data set and creates the table on it's work space which is why it takes 8 minutes. Query : 1 proc sql; drop table work.table1; create table work.table1 as select * from trlib.Employee t1 inner join trlib.Salary t2 on t1.empid = t2.empid quit I then figured there is a way to directly run the whole thing on Teradata (in it's spool space )and create the table on TD itself and then bring back the results on SAS for further processing /analysis. The same query actually ran in 30 sec from SAS as opposed to 8 mins when run on SAS work space. Query 2: proc sql; connect to teradata (user="john" server="apple" pw="test123" mode="teradata" ); execute (create table as select * from …. ) by teradata; quit; Thanks!
... View more