Trying to join 2 SAS dataset of 4 columns, around 5 million rows each. Received the error shown in the log below. C drive indicate 355M free space. 16GB is available on 😧 Drive. Do I need to reconfigure so that EG will use 😧 drive for temproary files? How would I do that?
Thanks
1 The SAS System 17:55 Wednesday, July 29, 2009
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 LIBNAME EC100008 "C:\Documents and Settings\demowituzi\My Documents\My SAS
3 ! Files\Sept_Event";
NOTE: Libname EC100008 refers to the same physical library as EC100010.
NOTE: Libref EC100008 was successfully assigned as follows:
Engine: V9
Physical Name: C:\Documents and Settings\demowituzi\My Documents\My SAS Files\Sept_Event
4
5 LIBNAME EC100009 "C:\Documents and Settings\demowituzi\My Documents\My SAS
5 ! Files\Sept_Event";
NOTE: Libname EC100009 refers to the same physical library as EC100008.
NOTE: Libref EC100009 was successfully assigned as follows:
Engine: V9
Physical Name: C:\Documents and Settings\demowituzi\My Documents\My SAS Files\Sept_Event
6
7 LIBNAME EC100010 "C:\Documents and Settings\demowituzi\My Documents\My SAS
7 ! Files\Sept_Event";
NOTE: Libname EC100010 refers to the same physical library as EC100009.
NOTE: Libref EC100010 was successfully assigned as follows:
Engine: V9
Physical Name: C:\Documents and Settings\demowituzi\My Documents\My SAS Files\Sept_Event
8
9
10 %LET _CLIENTTASKLABEL=%NRBQUOTE(Query for _905_0907);
11 %LET _EGTASKLABEL=%NRBQUOTE(Query for _905_0907);
12 %LET _CLIENTPROJECTNAME=%NRBQUOTE();
13
14 ODS _ALL_ CLOSE;
NOTE: Some of your options or statements may not be supported with the Activex or Java series of
devices. Graph defaults for these drivers may be different from other SAS/GRAPH device
drivers. For further information, please contact Technical Support.
15 OPTIONS DEV=ACTIVEX;
16 FILENAME EGHTML TEMP;
NOTE: Writing HTML(EGHTML) Body file: EGHTML
17 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' STYLE=EGDefault
17 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared%20Files/BIClientStyles/EGDefault.css
17 ! ") ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v91/sasgraph.exe") NOGTITLE
17 ! NOGFOOTNOTE GPATH=&sasworklocation;
18
19 %gaccessible;
20 %_eg_conditional_dropds(SASUSER.Query_for__905_0907);
21
22 PROC SQL;
23 CREATE TABLE SASUSER.Query_for__905_0907 AS SELECT _905_0907.DateAndTime
23 ! FORMAT=DATETIME19.,
24 _905_0907.TagIndex,
25 _905_0907.Val
26 FROM EC100008._905_0907 AS _905_0907
27 INNER JOIN EC100009._905_0907 AS _905_09071 ON (_905_0907.TagIndex =
27 ! _905_09071.TagIndex)
28 INNER JOIN EC100010._910_0914 AS _910_0914 ON (_905_0907.TagIndex =
28 ! _910_0914.TagIndex)
29 WHERE _905_0907.TagIndex = 0
2 The SAS System 17:55 Wednesday, July 29, 2009
30 ORDER BY _905_0907.DateAndTime;
ERROR: Write to WORK._tf0056.UTILITY failed. File is full and may be damaged.
NOTE: Error was encountered during utility-file processing. You may be able to execute the SQL
statement successfully if you allocate more space to the WORK library.
ERROR: Insufficient space in file SASUSER.QUERY_FOR__905_0907.DATA.
ERROR: Invalid sequence of commands for file SASUSER.QUERY_FOR__905_0907.DATA.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
31 QUIT;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 17.07 seconds
cpu time 16.34 seconds
32
33
34
35
36
37
38 %LET _CLIENTTASKLABEL=;
39 %LET _EGTASKLABEL=;
40 %LET _CLIENTPROJECTNAME=;
41
42 ;*';*";*/;quit;run;
43 ODS _ALL_ CLOSE;
44
45
46 QUIT; RUN;
47
... View more
