I created a oracle library to use as "work" in sas guide, where the users can create "work" tables directly in oracle. In our cenary the dimensions and facts are in oracle enviroment and this approach otimises the querys. I searching for a way to delete this "oracle work tables" after the end of the sas session.
You can easily clear all datasets from a library (source😞
proc datasets library=lib kill; run; quit;
I'm not sure if there's an equivalent to the autoexec but at the end, rather than beginning, of a SAS session. This could be a good opportunity to educate the users on the difference between work and permanent libraries, but I agree that it would be nice to have this functionality.
We have SAS Enterprise BI, but we only use SAS Data Integration (sas batch server), SAS Enterprise Guide and SAS Web Report Studio. Our BI is in low demand, our users are mainly using SAS Guide to perform analyzes directly in our Oracle database (90% of our data is in Oracle).
Our users love SAS Guide.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.