Help using Base SAS procedures

ERROR: Insufficient space in file WORK

Reply
Contributor
Posts: 28

ERROR: Insufficient space in file WORK

Hi All,
 
Could someone guide me on how to resolve the below error in SAS University Edition.While running a merge Data step, since the file is big, I am getting the below error. Even I tried to delete some unwanted datasets in Work LIbrary, still getting the same issue.
 
ERROR: Insufficient space in file WORK.PRICE_A.DATA.
ERROR: File WORK.PRICE_A.DATA is damaged. I/O processing did not complete.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 491547 observations read from the data set WORK.US_STOCK_PRICE.
NOTE: There were 704 observations read from the data set WORK.SEC_IND.
WARNING: The data set WORK.PRICE_A may be incomplete. When this step was stopped there were 491797 observations and 12 variables.
WARNING: Data set WORK.PRICE_A was not replaced because this step was stopped.
 
Many Thanks!!!
Trusted Advisor
Posts: 1,568

Re: ERROR: Insufficient space in file WORK

If yor code is one step only you can use libname USER assigned by yourself to a local big space, like:

 

libname user '...disk area under myfolders ...';

no need to change your code. sas will use libname USER automatically instead WORK.

 

If there are many steps you can add in between steps of deleting non used datasets, for eample:

data c;
    set a b;  
run;
/* no more use of datasets a b */

proc datasets lib=work nolist;
  delete a b;
run; quit;

 

 

Contributor
Posts: 28

Re: ERROR: Insufficient space in file WORK

Shmuel, Thanks much for your reply!

I will try using Libname statement, I will come back if I again face the issue.

 

 

Super User
Posts: 19,815

Re: ERROR: Insufficient space in file WORK

Sometimes, hopefully not in this case, you may need to reinstall SAS to remove the error. It seems to not clean up something from bad crashes and then your work get's permanently full.
Trusted Advisor
Posts: 1,568

Re: ERROR: Insufficient space in file WORK

@Reeza, assuming this is the case, should next code - being first code to run -  help?

proc datasets lib=work kill; run; quit;
Super User
Posts: 7,803

Re: ERROR: Insufficient space in file WORK


Shmuel wrote:

@Reeza, assuming this is the case, should next code - being first code to run -  help?

proc datasets lib=work kill; run; quit;

No, that only cleans the current WORK directory. Orphaned WORK directories from previously crashed sessions must be cleaned with the cleanutil utility, but that can't be used on SAS UE (no XCMD or console access). That's why I posted my Ballot Idea that UE cleans its temporary spaces on its own when it is (re)started.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 7,803

Re: ERROR: Insufficient space in file WORK

You can add your vote on https://communities.sas.com/t5/SASware-Ballot-Ideas/Do-a-thorough-clean-in-SAS-University-Edition/id..., which deals with this kind of problems.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 5,430

Re: ERROR: Insufficient space in file WORK

SAS UE is a learning edition so you should be able limit your data sets drastically and still learn.
Data never sleeps
Super User
Posts: 7,803

Re: ERROR: Insufficient space in file WORK


LinusH wrote:
SAS UE is a learning edition so you should be able limit your data sets drastically and still learn.

Yeah, but 491547 observations (as stated in the OP) should be far removed from the 10 GB space limit of SAS UE.

If the OP kept lots of intermediate datasets in WORK up to this point, inspecting and cleaning the WORK may help. But if it's the problem with the leftover WORKS, a reinstallation of SAS UE might be in order.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 10,028

Re: ERROR: Insufficient space in file WORK

You can make that shared fold to your WORK library.

 

options  user='/folders/myfolders/';

Super User
Posts: 5,430

Re: ERROR: Insufficient space in file WORK

@KurtBremser given 32k variables though...but yeah, I get your point ;-)
Data never sleeps
Ask a Question
Discussion stats
  • 10 replies
  • 547 views
  • 12 likes
  • 6 in conversation