topic Re: proc delete data set if exists in SAS Programming

proc delete data set if exists

Ronein — Tue, 20 Jul 2021 07:53:32 GMT

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;

Re: proc delete data set if exists

Kurt_Bremser — Tue, 20 Jul 2021 08:02:53 GMT

Wrap it into %IF %THEN:

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

Re: proc delete data set if exists

Ksharp — Tue, 20 Jul 2021 12:46:21 GMT

Write some dummy code before PROC DELETE ?

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

Re: proc delete data set if exists

ballardw — Tue, 20 Jul 2021 15:03:15 GMT

Proc datasets with the NOWARN and NODETAILS options.

Re: proc delete data set if exists

AllanBowe — Fri, 30 Jul 2021 19:32:37 GMT

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