Exception criteria exceeded : CPU time in SAS . How to resolve this error?

44 views Asked by At

I have a query regarding a piece of code that generates an automated report in Teradata.

PROC SQL;
&connect_db
execute (
CREATE TABLE table1 AS
(
 SELECT a.x1, a.x2, a.x3, b.y1
 FROM PreviousTable a LEFT JOIN DailyTable b
 ON a.acct_id = b.acct_id
 WHERE b.acct_ind =1 AND
 b.date <= a.date
) 
WITH DATA;
) by  db;
QUIT;

So in the above query throws Exception criteria exceeded : CPU Time. Could you help me understand how we change this CPU time error

0

There are 0 answers