Production Ready Macros for SAS Application Developers
mp_dropmembers.sas
Go to the documentation of this file.
1 /**
2  @file
3  @brief Drops tables / views (if they exist) without warnings in the log
4  @details
5  Example usage:
6 
7  proc sql;
8  create table data1 as select * from sashelp.class;
9  create view view2 as select * from sashelp.class;
10  %mp_dropmembers(list=data1 view2)
11 
12 
13  @param list space separated list of datasets / views
14  @param libref= can only drop from a single library at a time
15 
16  @version 9.2
17  @author Allan Bowe
18 
19 **/
20 
21 %macro mp_dropmembers(
22  list /* space separated list of datasets / views */
23  ,libref=WORK /* can only drop from a single library at a time */
24 )/*/STORE SOURCE*/;
25 
26  proc datasets lib=&libref nolist;
27  delete &list;
28  delete &list /mtype=view;
29  run;
30 %mend;