Here is a macro to quickly cleanup the work directory programmatically…
It uses Proc Datasets with KILL option to delete the datasets in the library…
%macro CleanupWORK(membertype); |
ACCESS - access descriptor files (created by SAS/ACCESS software) |
MDDB - multidimensional database |
PROGRAM - stored compiled SAS programs |
%let validvals=ACCESS ALL CATALOG DATA FDB MDDB PROGRAM VIEW; |
%if %index(&validvals,%upcase(&membertype)) gt 0 %then |
proc datasets lib=WORK kill nolist memtype=%upcase(&membertype); |
The valid values for the parameter memtype are ACCESS ALL CATALOG DATA FDB MDDB PROGRAM VIEW only…