02-16-2018 12:28 PM
*Using SAS EG, process is full of EG queries. Not written code*
I currently have a long multi step process in SAS. However, after completing about half of the process, I receive the error that there is insufficient space in my work library. I have reached out to our tech team to increase my work library size, however have no been successful.
Instead of increasing size, I have come up with the idea to clear my workspace right before my process receives the error. I am trying to do this by exporting the query into a SAS library, cleaning out the work space, them re importing the export to pick up where I left off. I have been successful in exporting out the data but have become stuck on how to tell sas to clear the workspace. I found the following code and have inputted it using file > new> process code. It does work to clear out my work library, however I am stuck trying to make it occur after the export.
proc datasets lib=work kill nolist memtype=data; quit;
How would I link that code into my work flow?
02-18-2018 10:29 PM
Not too sure I understand your question.
This aside, it may be better to use this in your case:
proc datasets noprint mt=data; save TABLE1TOSAVE; run;
rather than the kill option, to avoid copying data back and forth.