Dears,
I was running my program in SAS Studio 3.5 ( SAS 9.4) and the error occurred.
My Work Area has triple size of table used in the program.
So what does your program do?
You probably need to expand the disk for your saswork. If you just have triple the size of this particular data set, chances are that you in a near future will need to work on a bigger data set.
What is the size of your data. Is it SAS studio installed on a server in your company or SAS UE?
My select return 20Gb and my Work Area has 15Gb.
I use SAS Studio installed on a server in my company.
Can I allocate space in other Linux directories ?
Wich are best pratices to config my Work resources ?
Usually WORK disk space is shared between users. Allocating space per user is an inefficient approach. You should talk to your SAS server administrator to find out what options you have for getting more space.
Sorry. Please Ignore me . I enter wrong position.
Triple is not enough. When doing a PROC SORT, you need
- the space where the file is stored
- the space for the SORT utility file, which is at least the size of the original dataset, more if compress=yes was used)
- the space for the resulting file
Although the utility file and the old file will be deleted when the step has finished, at peak you need triple + reserve, or you will fail.
PROC SQL will also at times create huge utility files that can easily crack the limit of your WORK.
Possible remedies
- increase your WORK
- use a second file system for utility files (UTILLOC in your SAS config controls this)
- help yourself with some tricks like the TAGSORT option for PROC SORT
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.
Early bird rate extended! Save $200 when you sign up by March 31.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.