Throwing in my 2 cents worth.... It looks like you need to delete the entire dataset rather than a single SAS table. My first course of action would be to identify who has the lock on the file, otherwise we have had success just running a DOS command to delete the file at the appropriate time. Here is a sample where we clean out a dataset of all html files before rewriting them. This could be easily change to delete the entire file. Just run the macro with the name of the file: %macro deletefile(filen); %let delcmd1 = DEL "&prefix.\*.html "; %put deleting &filen data; data _null_; X &delcmd1; run; %mend;
... View more