DATA Step, Macro, Functions and more

ERROR: An I/O error has occurred on file

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

ERROR: An I/O error has occurred on file

Hi experts,

 

There is a big inner join which takes approximately 20 minutes before. But today we are getting an error like this

 

(saswork space is 2 TB)

 

NOTE: There were 34434671 observations read from the data set  <table_name>

ERROR: An I/O error has occurred on file <table_name>

ERROR: Failure while merging sorted runs from utility file 1 to final output.

ERROR: Failure encountered during external sort.

ERROR: File  <table_name> is damaged. I/O processing did not complete.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set.

 

 

Many thanks,

Best Regards


Accepted Solutions
Solution
‎05-08-2018 05:38 AM
Super User
Posts: 10,623

Re: ERROR: An I/O error has occurred on file

You're running out of space in the target library. Aside from a simple overall-out-of-space condition, you could also have an overrun of your individual quota.

Note: if everything is located in WORK, you need at least three times the size of the source table (source table, utility file, target table). If your table is stored with compress=yes, the utility file will be considerably larger than the source table, as it is not compressed. The tagsort option can be helpful in such cases.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

View solution in original post


All Replies
Solution
‎05-08-2018 05:38 AM
Super User
Posts: 10,623

Re: ERROR: An I/O error has occurred on file

You're running out of space in the target library. Aside from a simple overall-out-of-space condition, you could also have an overrun of your individual quota.

Note: if everything is located in WORK, you need at least three times the size of the source table (source table, utility file, target table). If your table is stored with compress=yes, the utility file will be considerably larger than the source table, as it is not compressed. The tagsort option can be helpful in such cases.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 668 views
  • 1 like
  • 2 in conversation