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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.