Sum of counts

SASPhile — Sun, 02 Dec 2012 05:12:45 GMT

The following query will give counts of each country_cd.But how to get the total of all counts?

proc sql;

select count(*) from table a

group by country_cd;

quit;

if there are 10 country_cd we will get 10 counts for each country.But how to get grand total of all 10 counts?

Re: Sum of counts

pobel — Sun, 02 Dec 2012 05:27:33 GMT

You can get the the total counts by not using the GROUP BY clause:

proc sql;

select count(*) from table a;

quit;