cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
venkatviswanath
Calcite | Level 5 venkatviswanath
Calcite | Level 5
Go to Solution

ERROR: Insufficient Space in file WORK.'SASTMP-000000059'n.UTILITY - while Using SAS DI

Posted 08-19-2022 02:39 AM (2080 views)

Hi,

I am getting a error while executing in SAS DI

 

ERROR: Insufficient Space in file WORK.'SASTMP-000000059'n.UTILITY.

ERROR: File WORK.'SASTMP-000000059'n.UTILITY is damaged. I/O Processing did not Complete.

ERROR: There is not enough space to store some intermediate results during join processing.

ERROR: SQL View WORK.WQ381AF Could not be processed.

 

Can you please provide me the solution for this    

0 Likes
Reply
1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: ERROR: Insufficient Space in file WORK.'SASTMP-000000059'n.UTILITY - while Using SAS DI

Posted 08-19-2022 04:34 AM (2054 views)  |   In reply to venkatviswanath

You are running out of space in WORK. Since this seems to happen in user written code, show us the complete code from the failing step so we can make suggestions.

Also look at what is present in WORK at this particular time, and delete all data which is no longer needed.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

View solution in original post

0 Likes
Reply
2 REPLIES 2
Kurt_Bremser
Super User Kurt_Bremser
Super User

Re: ERROR: Insufficient Space in file WORK.'SASTMP-000000059'n.UTILITY - while Using SAS DI

Posted 08-19-2022 04:34 AM (2055 views)  |   In reply to venkatviswanath

You are running out of space in WORK. Since this seems to happen in user written code, show us the complete code from the failing step so we can make suggestions.

Also look at what is present in WORK at this particular time, and delete all data which is no longer needed.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
0 Likes
Reply
venkatviswanath
Calcite | Level 5 venkatviswanath
Calcite | Level 5

Re: ERROR: Insufficient Space in file WORK.'SASTMP-000000059'n.UTILITY - while Using SAS DI

Posted 08-19-2022 08:11 AM (2026 views)  |   In reply to Kurt_Bremser
Thank You Kurt Bremser,
Our coder rectified the code.

Thank you for your help.
0 Likes
Reply

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Watch SAS Enterprise Guide vs. SAS Studio on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • ‎08-19-2022 02:39 AM
  • 2081 views
  • 0 likes
  • 2 in conversation