05-17-2016 01:24 PM
I have scheduled code that makes the same table each night, which is shared. Some people accidentally leave the table open - then it does not update.
Is there a way in the code to close the table in someone else's session?
05-17-2016 03:46 PM
But you can use operating system commands to delete the file. At least in UNIX it is possible to remove a directory entry although the file is open.
05-17-2016 04:35 PM
05-18-2016 01:23 AM
That would work since I am replacing the table anyway. We have tried proc delete commands and it does not work since it is someone else's session.
What operating system commands should we attempt?
This depends on the operating system that SAS is installed on. If it is UNIX, I can provide a macro that physically deletes a dataset no matter what.
05-17-2016 04:05 PM
The issue of sharing/opening SAS datasets while trying to also update them has been the subject of innumerable discussions over the years...
The bottom line is there is no easy answer but here are a few ways to deal with this:
05-17-2016 04:39 PM
05-17-2016 07:35 PM
Thanks @LinusH. I've never used SAS/SHARE but I think depending on the update method being used this could work judging by what I see in this link (assuming of course that all users access the multi-user table via a SAS/SHARE server):
05-18-2016 01:10 AM