Solved
Contributor
Posts: 73

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

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.

Regards,

Ritesh

Accepted Solutions
Solution
‎02-22-2017 02:40 PM
Frequent Contributor
Posts: 75

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

[ Edited ]

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;``````

All Replies
Solution
‎02-22-2017 02:40 PM
Frequent Contributor
Posts: 75

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

[ Edited ]

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;``````

Contributor
Posts: 73

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

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?

Regards,

Ritesh

Frequent Contributor
Posts: 75

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

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;``````
Super User
Posts: 10,850

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

Better use NLOBS .

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