I have a few datasets in my library and I want to delete datasets which has zero records , can anyone create macro to do that?
No macro needed. Assuming you want to delete from the Library named WORK, this is how to do it:
proc sql noprint;
select distinct memname into :zeros separated by ' ' from sashelp.vtable where nobs=0 and libname='WORK';
quit;
proc datasets library=work;
delete &zeros;
run;
quit;
Naturally, if the Library name is different you have to modify the code above to refer to a different library. In SQL, the library name must be upper case. Also, the datasets are deleted without warning.
No macro needed. Assuming you want to delete from the Library named WORK, this is how to do it:
proc sql noprint;
select distinct memname into :zeros separated by ' ' from sashelp.vtable where nobs=0 and libname='WORK';
quit;
proc datasets library=work;
delete &zeros;
run;
quit;
Naturally, if the Library name is different you have to modify the code above to refer to a different library. In SQL, the library name must be upper case. Also, the datasets are deleted without warning.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: