re: List datasets in library

[twildone]

Hi....I am trying to list the names of the data sets in the library "sqldb" and the variable names in each data set. I want to exclude those data sets that have no records and are empty. Is there a feature that I can add to the proc contents statement that would exclude data sets that are empty? Thanks.

libname sqldb odbc DSN=darwin;
run;
proc contents data=sqldb._ALL_ varnum ;
run;

[RW9]

You can use sashelp.vcolumns and vtable:

proc sql;
  create table WANT as
  select * 
  from   SASHELP.VCOLUMNS
  where  LIBNAME="SQLDB"
     and MEMNAME in (select distinct MEMNAME from SASHELP.VTABLE where LIBNAME="SQLDB" and NOBS > 0);
quit;

Then print want.