Has anyoen ever encountered a situation where they were unable to delete data sets within a specific SAS libary using Proc Datasets when the code was run as a stored process, while having no issues/problems doing so when run from an EG code node? When I run the exact same code from a code node, the data sets are deleted (as intended) without any issues. However, when I run the exact same code as a stored process, the log is telling me that it can't (delete them) because they are currently in use (which they're not, at least not by anything that the stored process it itself.). These are SPDE tables that I am attempting to programmatically delete. Any ideas?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.