Hello,
I want to get summation of a variable by different groups using PROC REPORT procedure.
For example, I want to compute the summation of invoice by origin in the sashelp.cars
proc report data=sashelp.cars;
column (invoice, sum);
title 'invoice';
run;
Instead of repeating with WHERE statement for every value of the variable, is there a way to do this in a different way in one table?
proc report data=sashelp.cars; where origin='Europe';
column (invoice, sum);
title 'invoice';
run;
proc report data=sashelp.cars; where origin='USA';
column (invoice, sum);
title 'invoice';
run;
proc report data=sashelp.cars; where origin='Asia';
column (invoice, sum);
title 'invoice';
run;
Many thanks in advance.