Date:         Wed, 6 Sep 2000 15:55:33 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Antwort:
Comments: To: lend@iwon.com
Content-type: text/plain; charset=us-ascii

This may be a good chance to show how much PROC SYNCSORT is worth !
Remove the proc summary, by just adding a SUM statement into the proc sort

PROC SORT DATA=WORK.GOOD5 OUT=COMBINE0 ;
 BY ACCOUNT CUSTSEG DEPT_ID FRL_LINE SOURCE SRCEGRP PERIOD ;
 SUM _NUMERIC_;
RUN;


If _numeric_ is not accepted, then you could generate that varlist with

%let bylist = ACCOUNT CUSTSEG DEPT_ID FRL_LINE SOURCE SRCEGRP PERIOD ;
%let Qbylist = "%sysfunc( tranwrd( &bylist, %str( ), %str(", ") ))";

proc sql noprint;
 select name into :VARLIST separated by ' '
   from dictionary.columns
  where libname ='WORK' and memname ='GOOD5' and type = 'num' and
           name not in (&Qbylist)
     ;
quit;

Then the sort statements can be simplified to----------

PROC SORT DATA=WORK.GOOD5 OUT=COMBINE0 ;
 BY   &bylist ;
 SUM &varlist;
RUN;



Datum:         06.09.2000 15:35
An:            SAS-L@listserv.uga.edu




Antwort an:    lend@iwon.com

Betreff:
Nachrichtentext:


Hi All,

I've tried every possible way to solve this problem i.e.
memsize=0, increased work space allocation.  But the problem
still persists. Here's the log:

MPRINT(RPTRUN):   PROC SORT DATA=WORK.GOOD5 OUT=COMBINE0 ;
MPRINT(RPTRUN):   BY ACCOUNT CUSTSEG DEPT_ID FRL_LINE SOURCE SRCEGRP PERIOD
MPRINT(RPTRUN):   RUN;

NOTE: WER750I End PROC SYNCSORT.  R2.2A
NOTE: The data set WORK.COMBINE0 has 1557216 observations and 35 variables.
NOTE: The PROCEDURE SORT used the following resources:
CPU     time -         00:00:06.33
Elapsed time -         00:02:47.24
Vector affinity time - 00:00:00.00
Vector usage    time - 00:00:00.00

RSM Hiperspace  time - 00:00:00.00
EXCP count   - 948
Task  memory - 1763K (20K data, 1743K program)
Total memory - 4892K (2084K data, 2808K program)

MPRINT(RPTRUN):   PROC SUMMARY DATA=COMBINE0 NWAY MISSING;
MPRINT(RPTRUN):   BY ACCOUNT CUSTSEG DEPT_ID FRL_LINE SOURCE SRCEGRP PERIOD;
MPRINT(RPTRUN):   VAR _NUMERIC_;
MPRINT(RPTRUN):   OUTPUT OUT=COMBINE1(DROP=_TYPE_ _FREQ_) SUM=;
MPRINT(RPTRUN):   RUN;

ERROR: Insufficient space in file WORK.COMBINE1.DATA.
ERROR: Insufficient space in file WORK.COMBINE1.DATA.
ERROR: Insufficient space in file WORK.COMBINE1.DATA.
NOTE: The SAS System stopped processing this step because of errors.

NOTE: SAS set option OBS=0 and will continue to check statements. This may c
WARNING: The data set WORK.COMBINE1 may be incomplete.  When this step was s
NOTE: The PROCEDURE SUMMARY used the following resources:
CPU     time -         00:00:16.01
Elapsed time -         00:01:14.20

Is there a workaround that you guys can suggest.  By the
way, I am using v609 on the mainframe.

Would appreciate your help.

Thanks.

010400
Home Phone - 415-382-0920
Cell Phone    - 415-533-1950
Work Phone  - 415-899-2357
........................................................
iWon.com       http://www.iwon.com     why wouldn't you?
........................................................