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: 63
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 ]

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 ]

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

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?

 

thanks in advance.

 

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: 9,676

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.

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

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