topic Total sales by departement in New SAS User

Total sales by departement

Bertrice — Mon, 08 Oct 2018 08:00:58 GMT

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.

Re: Total sales by departement

Kurt_Bremser — Mon, 08 Oct 2018 08:09:58 GMT

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

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

Re: Total sales by departement

RW9 — Mon, 08 Oct 2018 08:10:02 GMT

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.