How to know dataset contain data

[thanikondharish]

I have libray . library name is Main. Main library has some many datasets .In those datasets some datasets contain only variables there is no data and some datasets has data.
My question is how to know which datasets have data and which datasets haven't data at time

[rajeshalwayswel]

%let dsid=%sysfunc(open(sashelp.class));
%let nobs=%sysfunc(attrn(&dsid,nlobs));
%let dsid=%sysfunc(close(&dsid));

%put nobs= &nobs ;

[Kurt_Bremser]

Query the relevant dictionary table for this:

proc sql;
create table empties as
select memname from dictionary.tables
where libname = 'MAIN' and nobs = 0;
quit;

[s_lassen]

DICTIONARY.TABLES is good for that:

proc sql;
  select memname,nlobs from dictionary.tables
  where libname='MAIN';
quit;

I used NLOBS rather than NOBS, because NOBS includes deleted observations.

You can use a create table clause to put the stuff in a dataset, or you can put the table names that you want in a macro variable, e.g.:

proc sql noprint;
  select memname into :notempty separated by ' '
  from dictionary.tables where libname='MAIN' and NLOBS>0;
quit;