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
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.
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.
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.
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).
Post the code of what you submit that causes the problem and describe the data set(s) involved.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.