DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Contributor
Posts: 68
Accepted Solution

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.

 

thanks in advance.

 

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 ]
Posted in reply to Ritesh_dellvostro

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;

 

 

View solution in original post


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 ]
Posted in reply to Ritesh_dellvostro

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: 68

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

Posted in reply to nehalsanghvi

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

 

 

Frequent Contributor
Posts: 75

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

Posted in reply to Ritesh_dellvostro

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,020

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

Posted in reply to Ritesh_dellvostro

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 240 views
  • 1 like
  • 3 in conversation