Total sales by departement

[Bertrice]

I have a table  contains the column of  stores, département , date and  sale by week

I would like to know how I can write to get the total sales by departement. there are 98 departement .

and( magasin 1 ) for exemple has is  every week sale  for 2 years.

[Kurt_Bremser]

proc sql;
select department, sum(sale)
from have
group by department;
quit;

The most simple approach to creating sums for groups in SQL.

[RW9]

We need to see test data in the form of a datastep and required output to have any chance of answering your question.  As such all I can say is that proc means/summary/sql are ways of getting total counts.