清空work逻辑库下的所有数据集
如题。
用程序如何实现?
删除少数几个可以这样:
proc datasets lib=work;
delete out1 out2;
run;
但如果数据集较多,无法列出,有没有办法一下子全部清空呢?
答案如下:
PROC DATASETS LIB = work KILL;
RUN;
另附:
SAS 批量删除数据集
这个语句可以起到作用,
proc delete data=a1 a2 a3;run;
但是这么写就不行,sas不认,
proc delete data=a1-a3;run;
只能用宏,
%macro dd;
%do i=1 %to 99;
proc delete data=a&i;run;
%end;
%mend;
?1?7;
但是用datasets步可以搞定,
proc datasets lib=work ;delete a1-a99;run;
下面这些也都可以
proc delete lib=work;data=_all_; run;
proc delete lib=work;data=a:; run;
PROC DATASETS LIB = work KILL;
RUN;