proc delete data set if exists

[Ronein]

Hello

I want to see a code that delete a data set if the data set exists.

When I run the following code for a data set that doesn't exist then I get warning. 

WARNING: File work.XX.DATA does not exist.

proc delete data=XX;Run;

[Kurt_Bremser · Accepted solution]

Wrap it into %IF %THEN:

%if %sysfunc(exist(xx))
%then %do;
proc delete data=XX;
run;
%end;

[Ksharp]

Write some dummy code before PROC DELETE ?

data xx;xx=1;run;
proc delete data=XX;Run;

[ballardw]

Proc datasets with the NOWARN and NODETAILS options.

[AllanBowe]

The following macro can be used to remove multiple tables without warnings if they don't exist, it will also work just the same for views (so you don't need to test for that either):

https://core.sasjs.io/mp__dropmembers_8sas.html