Production Ready Macros for SAS Application Developers File Reference

Drops tables / views (if they exist) without warnings in the log. More...

Go to the source code of this file.

Detailed Description

Useful for dropping tables when you're not sure they exist, or if you are not sure whether they are a dataset or view. Also efficient for dropping multiple tables / views.

Example usage:

proc sql;
create table data1 as select * from sashelp.class;
create view view2 as select * from sashelp.class;
%mp_dropmembers(data1 view2, libref=WORK)

SAS Macros

listspace separated list of datasets / views, WITHOUT libref
libref=(WORK) Note - you can only drop from a single library at a time
Allan Bowe

Definition in file