topic Re: How to find all the datasets in a library with zero observation and create a dataset with the dataset names? in SAS Programming

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

Linlin — Wed, 19 Dec 2012 14:55:52 GMT

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 — Wed, 19 Dec 2012 15:02:05 GMT

Linlin,

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

Haikuo

Linlin — Wed, 19 Dec 2012 15:15:44 GMT

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 — Thu, 20 Dec 2012 01:39:32 GMT

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 — Thu, 20 Dec 2012 02:53:02 GMT

Good point. Thank you Ksharp! - Linlin

smonodeep — Sun, 23 Dec 2012 20:05:58 GMT

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;