I'm new SAS and still learning my way around. I've connected to SQL Server via SAS using ODBC connection. I used PROC SQL statement to create a table, this took around 10 second. But then, when I try to query that table it takes a long time. So far I waited 8 min before stopping the process. Similar thing happens when I try to JOIN the newly created table to another table from SQL Server. Is there anything I can do to speed up the process? Thank you Here is the code that I'm using proc sql;
CREATE TABLE ActiveIB as
SELECT distinct col1
,col2
,col3
FROM CAM.FactTable
where Col4= 'Active'
and (DateCol is NULL or DateCol <= '01DEC2017'd)
;
quit; proc sql outobs=10; select * from ActiveIB ; quit;
... View more