How can I get total counts of observations of 100 datasets in one shot.

[Riteshdell]

Hello Techiez,

I need help to get total count of observation in all dataset from a Library.

Suppose a library contains 50 datasets(tables).

Some table have X observation , some has Y observation.

Want total count of all the datasets.

thanks in advance.

Regards,

Ritesh

[nehalsanghvi · Accepted solution]

This example uses work library, but you can substitute your own lib:

proc sql;
select sum(nobs) as TotalRows
from dictionary.tables
where libname eq 'WORK';
quit;

[Riteshdell]

thanks nehalsanghv you really solved my query.

A new question came to my mind realted to same.

Suppose A library contains 100 dataset, and i want only 50 dataset count ( selective dataset).

Is it possible?

thanks in advance.

Regards,

Ritesh

[nehalsanghvi]

Dataset names are listed in the memname column of dictionary.tables. You can list the memname values you want in the where statement. Give the entire dictionary table a look with a select *, there is a lot of useful metadata.

proc sql;
select sum(nobs)
from dictionary.tables
where libname = 'WORK'
and memname in ('TBL1','TBL2');
quit;

[Ksharp]

Better use NLOBS .

proc sql;
select sum(nlobs) as TotalRows
from dictionary.tables
where libname eq 'WORK' and memname like '%XX%';
quit;