SAS Enterprise guide fails: [Error] Library WORK does not exist

[Yarlanil59]

When using query builder it is showing. But I can use for other tables to create in sas work. Only some time it is showing this error.

Application Error
SAS Enterprise Guide needs to close
SAS Enterprise Guide has encountered a problem and needs to close. We are sorry for the inconvenience.

-------------------------------------------------------------------------------------------------------
Exception information
-------------------------------------------------------------------------------------------------------

[Error] Library WORK does not exist.

-------------------------- Technical Information Follows --------------------------

Exception Details:
----------------------------------------
Exception type: System.Data.OleDb.OleDbException
SAS Message: [Error] Library WORK does not exist.

Raw Message: <?xml version="1.0" ?><Exceptions><Exception><SASMessage severity="Error">Library WORK does not exist.</SASMessage></Exception></Exceptions>
Target Site: ExecuteCommandTextErrorHandling

[ChrisHemedinger]

Hi @Yarlanil59 - we'll need some more information.  What vesion of EG, and what version of SAS?  Are you running this on a SAS Grid Environment?

You might need to enable additional logging (Tools->Options->Application Logging in EG 7.1 and later) and work with SAS Technical Support to diagnose.

[Yarlanil59]

Thanks for the replySAS EG 7.13 and SAS 9.4. Not a grid environment. Standalone environment.
Insufficient space in file WORK.'SASTMP-000000033'n.UTILITY. 
ERROR: File WORK.'SASTMP-000000033'n.UTILITY is damaged. I/O processing did not complete.
But work space is 1.0TB free

[ballardw]

This bit:

[Error] Library WORK does not exist.

indicates a very major error. I've been using SAS off and on for nearly 30 years and have never seen that one.

I would close down SAS and restart and check the log before doing anything to see if there are start up issues. And veryify that teh WORK library is available.

[Yarlanil59]

Thanks for the reply.

Work library is available. I tried different code it worked fine. only when distinct is selected it is happening like that.

[ChrisHemedinger]

Assuming you're working with a large table or perhap a complex join, and that's creating a large utility table in WORK and filling up the space.  You might try chunking your query into steps, or reconsider any expensive operations (such as ORDER BY/sorted output).

[ballardw]

Post the code of what you submit that causes the problem and describe the data set(s) involved.

[Yarlanil59 · Accepted solution]

I very sorry for the confusion. The error which I mention is not causing by any code. We schedule a script to clean SAS WORK folders and somehow It was deleting my WORK folder while in use. I resolved it.