How to find all the datasets in a library with zero observation and create a dataset with the dataset names?

[Linlin]

Hi All,

I need to find all the datasets with zero observation in a library. How should I do that? Any suggestion is highly appreciated.

Thanks - Linlin

[Haikuo · Accepted solution]

Linlin,

Could you use dictionary.tables to find your info? there is a variable 'nobs' delivering what you need.

Haikuo

[Linlin]

Hi Haikuo,

Thank you very much! - Linlin

My code:

proc sql;

  create table want as

    select memname,nobs

   from dictionary.tables

     where libname='WORK' and memname like "_%" and nobs=0;

  quit;

proc print data=want;

run;

[Ksharp]

Recommend you use nlobs to instead fo nobs.

When Some data set be modified directly ,not random modified, NOBS will return not exactly the nobs.

[Linlin]

Good point. Thank you Ksharp! - Linlin

[smonodeep]

proc sql noprint;

create table temp/* if you want it use in a dataset*/ as select libname as library_name,

memname as Name

from sashelp.Vtable where Libname="Work" /* you can use any library*/

and nobs=0;

select count(*)

into:Nobs

from temp;

Select Name

into :Name1-:Name%left(&Nobs)

from temp;

quit;