Write and run SAS programs in your web browser

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

Reply
Occasional Contributor
Posts: 6

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

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. 

 

 

 

 

Super User
Posts: 5,382

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

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.

Data never sleeps
Super User
Posts: 19,059

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

What is the size of your data. Is it SAS studio installed on a server in your company or SAS UE?

Occasional Contributor
Posts: 6

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

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 ?  

Super User
Posts: 3,233

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

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.

Super User
Posts: 9,865

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

[ Edited ]

Sorry. Please Ignore me . I enter wrong position. 

Occasional Contributor
Posts: 6

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

?
Super User
Posts: 7,405

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 7 replies
  • 2635 views
  • 0 likes
  • 6 in conversation