Connecting Code to a EG Process

Amber_Nicole94 — Fri, 16 Feb 2018 17:28:15 GMT

*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?

Re: Connecting Code to a EG Process

ChrisNZ — Mon, 19 Feb 2018 03:29:50 GMT

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.

topic Re: Connecting Code to a EG Process in SAS Programming

Connecting Code to a EG Process

Re: Connecting Code to a EG Process