LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2000, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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? ........................................................


Back to: Top of message | Previous page | Main SAS-L page