topic Re: Clearing the work library on a Workspace in SAS Enterprise Guide

Clearing the work library on a Workspace

AlanC — Fri, 14 Dec 2018 15:35:48 GMT

I did not find a good place to ask this question so I figured EG would be the best location.

When we instantiate a new Workspace object in C#:

var ws = new Workspace();

var ls = ws.LanguageService

...and then we execute SAS code...

How do we then clear the work library that the ws used? I could submit a proc datasets but I figured there is probably a programmatic way to do it.

Re: Clearing the work library on a Workspace

Kurt_Bremser — Fri, 14 Dec 2018 15:40:29 GMT

proc datasets with kill IS the programmatic way to go.

Re: Clearing the work library on a Workspace

AlanC — Fri, 14 Dec 2018 15:43:57 GMT

In SAS language but it may not be the object way. For example, EG add-ins.

Re: Clearing the work library on a Workspace

ChrisHemedinger — Fri, 14 Dec 2018 15:48:18 GMT

Hi @AlanC - actually, I think the best way is probably proc datasets lib=work kill.

There isn't any other method on the Workspace that abstracts this operation.

If you think that clearing the entire WORK library might have a side effect (removing something that you didn't explicitly create), then I recommend creating a new library that's located in a subfolder of the WORK space.

/* create a new lib as a subfolder of WORK */
options dlcreatedir;
libname mywork "%sysfunc(getoption(WORK))/mywork";

/* optional: one-level names will default to MYWORK lib */
options user=mywork;

/* Use and enjoy */
data one two three;
 set sashelp.class;
run;

/* cleanup MYWORK before the next task */
proc datasets nolist nodetails lib=mywork kill;

Re: Clearing the work library on a Workspace

AlanC — Fri, 14 Dec 2018 15:55:02 GMT

Thanks Chris. I have been exploring the libref object and nothing explicitly lets me list what is there (so I can loop and delete). Getting it confirmed that it is datasets is what I needed.

See you at SGF.

Re: Clearing the work library on a Workspace

ChrisHemedinger — Fri, 14 Dec 2018 16:08:57 GMT

If you're working with SAS custom tasks, then the Task Toolkit has a SasData class/namespace that can help you to enumerate all of these members. See this GitHub project for examples. Behind the scenes, these classes are using the SAS DICTIONARY tables to discover libraries, data sets, and their properties. The libref object in IOM is pretty limited and tricky to use.

These classes don't offer a delete method though.

Chris

Re: Clearing the work library on a Workspace

AlanC — Fri, 14 Dec 2018 16:34:55 GMT

I am instantiating n number of workspaces and enqueuing/dequeuing them, then reusing them. This saves the reinstantiation cost so I need the workspace cleared after each language use.