topic Re: Error: insufficient space in work folder in SAS Procedures

Error: insufficient space in work folder

fouke_o — Mon, 04 Nov 2019 14:40:57 GMT

Hi,

I keep getting the error:

ERROR: Insufficient space in file WORK.VISITSADULTCOUNT.DATA.

ERROR: File WORK.VISITSADULTCOUNT.DATA is damaged. I/O processing did not complete.

when I want to run the following code:

data VisitsAdultcount;
	set visitsadult;
	ynomenc=year(SS00015);
		by H18;
		if First.H18 then do;
		visitsA=0;
		if (ynomenc GE startFU) and VERSTR_CARDIO_VOLW=1 then visitsA+1;
		if (last.H18) then /*loop for 1 patient*/		
		output;
	end;
run;

H18 is my ID variable and my dataset contains approximately 15 million records. I want to count the number of visits for every person in the dataset.

Any idea how I can fix this or any other code I could use that wont give this issue?

Thanks!

Re: Error: insufficient space in work folder

KachiM — Mon, 04 Nov 2019 15:26:03 GMT

@fouke_o

I guess there must be some issue with your input data set.

Re: Error: insufficient space in work folder

SASKiwi — Mon, 04 Nov 2019 20:32:41 GMT

You've run out of disk space for your WORK dataset. Are you running SAS locally on your PC or on a remote SAS server?

If you are running SAS on your PC then delete any files you no longer need to free up space. Check your SASWORK folder to see if there are any old sub-folders that can be deleted.

If you are running remote SAS then consult your SAS administrator to free up more space.

Re: Error: insufficient space in work folder

fouke_o — Tue, 05 Nov 2019 09:35:09 GMT

I am running remote SAS, but my work folder is as good as empty.

Re: Error: insufficient space in work folder

LinusH — Tue, 05 Nov 2019 09:49:59 GMT

Contents of your folder doesn't say whether you are running out of disk space or not.

Contact you server admin to get help of analyzing disk space and your program behaviour.

Adding some options <might> give som more input on whats going on (in the future, provide the full log, instead of splitting up the message and the code):

options msglevel=i fullstimer;

Re: Error: insufficient space in work folder

Ksharp — Tue, 05 Nov 2019 12:52:59 GMT

Use this option to re-direction your WORK library.

options user='d:\temp\';

Re: Error: insufficient space in work folder

SASKiwi — Tue, 05 Nov 2019 19:17:44 GMT

On a remote server you will be sharing the WORK folder with other users who could be filling it up. Like I said, talk to your SAS admin.