topic Re: How can I get total counts of observations of 100 datasets in one shot. in SAS Programming

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

Riteshdell — Wed, 22 Feb 2017 19:18:27 GMT

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

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

nehalsanghvi — Wed, 22 Feb 2017 19:33:27 GMT

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;

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

Riteshdell — Wed, 22 Feb 2017 19:40:19 GMT

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

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

nehalsanghvi — Wed, 22 Feb 2017 19:46:57 GMT

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;

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

Ksharp — Thu, 23 Feb 2017 02:55:02 GMT

Better use NLOBS .

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