07-31-2013 02:07 PM
I was building an detailed project with lots of queries, however suddenly my project started to give the error message, i submitted bellow. I am not sure whats the problem because i was able to join tables previously
NOTE: Writing TAGSETS.SASREPORT12(EGSR) Body file: EGSR
13 GOPTIONS ACCESSIBLE;
16 PROC SQL;
17 CREATE TABLE WORK.BASE AS
18 SELECT DISTINCT t1.MUSTERI_NO,
24 FROM WORK.KKJOIN t1 LEFT JOIN WORK.TNA t2 ON (t1.MUSTERI_NO = t2.MUSTERI_NO);
ERROR: Sort execution failure.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 2.01 seconds
cpu time 1.90 seconds
08-01-2013 02:59 AM
Hi please can you give the exact dataset names and variables. Because the syntax you used in from is little bit not in proper order(generally dataset names
doesnot contain any blanks).