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 (November 1998, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 10 Nov 1998 15:47:13 -0500
Reply-To:     Bernard Tremblay <bernard@CAPITALE.QC.CA>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Bernard Tremblay <bernard@CAPITALE.QC.CA>
Subject:      Re: Funky Stuff in SAS?

Hi Karsteen and all,

May be it's not the disk full, but I still have some doubts... I've modified the config like this for large disk in the past:

-partsize 800M -work (/work1,/stat16,/stat11,/stat13,/stat10,/stat15,/stat12)

You give it a list of volumes to use for the work space. Be sure to have at least the partsize of free space on any of the disks.

But I have experimented with on a SunOS machine with SAS 6.12 and the sort program DID NOT supported large file anyway... It always filled the first partition and then abended... (Same for PROC SQL) You could always try to split the file in parts, sort the parts then merge them together... Or try a tagged sort and wait for long, long, long time...

Let us know the results of your experiments!

regards, Bernard Tremblay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>Date: Tue, 10 Nov 1998 14:49:51 -0500 >>>From: "Self, Karsten" <Karsten.Self@SCHWAB.COM> >>>Subject: Re: Funky Stuff in SAS? >>>Comments: To: "Ashiru, Babatunde" <AshiruB@WHITEOAKSEMI.COM> >>> >>>I disagree with Bernard's diagnosis. Disk full results in a dialog or >>>message "out of resources" or "insufficient space". Baba is running >>>HPUX. SAS does not offer native large file (> 2GB) support on this >>>platform, though a large file experimental mode is available. SASWORK >>>could be 10 GB or 10 TB, he still can't produce a single system file of >>>more than 2 GB. >>> >>>The workaround is to enable SAS large file support. The confirmation is >>>to watch file size and disk utilization within SAS WORK. >>> >>>You typically can't allocate space in Unix as on MVS. A filesystem, >>>once built, has a finite size, and is modifiable only by the root user. >>>Users may have quotas or resource limits imposed (man 'quotas' and >>>'ulimit'), though this usually isn't the case. You *can* point to a >>>larger space, if one is available, by specifying a different WORK system >>>option at SAS startup. >>> >>>2 GB is roughly: >>> >>> 1m records X 2k lrecl >>> 2m records X 1k lrecl >>> 4m records x 500 bytes lrecl >>> >>>...a pattern should be emerging. >>> >>> >>> >>>My usual question is whether or not the sort is necessary. It often >>>isn't, or can be postponed, if you can do subsetting with a format, >>>apply CLASS variables to a summary, or use an index. A standard >>>practice is: >>> >>> sort >>> subset >>> summarize >>> >>>A much more efficient method is: >>> >>> subset >>> summarize (based on existing collation sequence) >>> sort >>> summarize >>> >>>...tossing as much of the data as possible along the way and using views >>>where possible. The NOTSORTED option can be used to allow summarization >>>of data in which some grouping of like keys exists, but overall ordering >>>isn't guaranteed. >>> >>>I responded to an optimization problem last December on SAS-L which >>>makes an interesting case study. Original problem, tactics, final code, >>>and optimizations, are available in the following links. >>> >>> >>> >>> >>> >>>Karsten M. Self ( >>>Trilogy Consulting >>> >>> What part of "gestalt" don't you understand? >>> >>>WARNING: All e-mail sent to or from this address will be received by >>>the Charles Schwab corporate e-mail system and is subject to archival >>>and review by someone other than the recipient. >>> >>>> ---------- >>>> From: Ashiru, Babatunde[SMTP:AshiruB@WHITEOAKSEMI.COM] >>>> Reply To: Ashiru, Babatunde >>>> Sent: Tuesday, November 10, 1998 11:09 AM >>>> To: SAS-L@UGA.CC.UGA.EDU >>>> Subject: Re: Funky Stuff in SAS? >>>> >>>> Ok, points well taken but I have gotten as far as several hundred >>>> thoudsands >>>> over 1 million records in the past without any problem...albeit I >>>> seldom get >>>> I/O error message. We thought it was a tmp space problem; allocated >>>> more >>>> space and/or moved the process to another server with over 10 >>>> gigabytes of >>>> hard-disk space but all to no avail? >>>> >>>> BRA >>>> >>>> -----Original Message----- >>>> From: Bernard Tremblay [] >>>> Sent: Tuesday, November 10, 1998 2:05 PM >>>> To: AshiruB@WHITEOAKSEMI.COM >>>> Subject: Re: Funky Stuff in SAS? >>>> >>>> Hi, >>>> >>>> This funky stuff is called : DISK FULL ! >>>> >>>> You're out of space on the volume that is used for >>>> sorting >>>> (usualy the work library) or the volume where is the >>>> 'PRDCNTDS' >>>> library. >>>> Try allocate more work space or find another volume for it... >>>> >>>> regards, >>>> Bernard Tremblay >>>>

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