re: List datasets in library

twildone — Wed, 04 Oct 2017 14:04:53 GMT

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;

Re: re: List datasets in library

RW9 — Wed, 04 Oct 2017 14:33:17 GMT

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.

topic Re: re: List datasets in library in SAS Programming

re: List datasets in library

Re: re: List datasets in library