DATA Step, Macro, Functions and more

re: List datasets in library

Reply
Regular Contributor
Posts: 245

re: List datasets in library

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;
Super User
Super User
Posts: 9,441

Re: re: List datasets in library

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.

Ask a Question
Discussion stats
  • 1 reply
  • 119 views
  • 2 likes
  • 2 in conversation