*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?
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.