How to fix the error: I/O processing did not complete

[qc1]

I run a program to create tables. But I got errors like this:
“Error: Expecting page 43290, got page -1 instead.
Error: Page validation error while reading libname.tablename.DATA.
Error: File libname.tablename.DATA is damaged. I/O processing did not complete.
Note: compressed is 43289 pages; “

I used below code to repair the table:
Proc datasets lib=libname;
Repair tablename / encryptkey=secret;
Run;
Quit;

No errors for Proc dataset step and it seems like worked. But that table still cannot be query.

What code I should use to fix it? Please provide an example.

Please help! You will be gratefully appreciated!

[SASKiwi · Accepted solution]

This is usually an indication you have either run out of disk space or that there are hardware problems with your storage. What type of SAS installation are you running on. A PC, a remote SAS server, or on a cloud-based platform?   

[qc1]

I run it on a remote SAS server, using SASEG7.15

[SASKiwi]

In that case I suggest you talk to your SAS administrator or IT help desk about fixing this. If appropriate a restore from the last good backup might be the way to go.

[Kurt_Bremser]

This usually happens when SAS ran out of disk space while creating the dataset. Rerun the process which created the dataset in the first place.