Date:         Tue, 3 Dec 2002 13:54:20 +0100
Reply-To:     Jan Selchau-Hansen <jan@*SELCHAU-HANSEN.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jan Selchau-Hansen <jan@*SELCHAU-HANSEN.DK>
Organization: TDC Internet
Subject:      Re: Deleting files with 0 observations

Use PROC SQL with SASHELP.VTABLE to find the "empty tables"
and PROC DATASETS til delete them !
like this

%let libname=WORK;
proc sql noprint;
 select memname
 into :delmem
 separated by ' '
 from sashelp.vtable
 where libname="&libname" and nobs=0;
quit;
%put &delmem;
proc datasets nolist library= &libname ;
 delete &delmem;
run;quit;

Jan Selchau-Hansen

"גדי בן אבי" <GADI_B@MALAM.COM> skrev i en meddelelse
news:B3A415965C0CBC46AE5D76C9B90166AD215D16@jer-mailbox1.jer.ad.malam.com...
How can I delete all the files that have 0 observations in a library.

Gadi