topic Re: How to know dataset contain data in SAS Programming

How to know dataset contain data

thanikondharish — Wed, 29 Aug 2018 05:46:39 GMT

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

Re: How to know dataset contain data

rajeshalwayswel — Wed, 29 Aug 2018 05:55:32 GMT

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

%put nobs= &nobs ;

Re: How to know dataset contain data

Kurt_Bremser — Wed, 29 Aug 2018 06:01:15 GMT

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;

Re: How to know dataset contain data

s_lassen — Wed, 29 Aug 2018 11:21:57 GMT

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;