PROC REPORT by different groups for summation

sasworker16 — Sun, 10 Jan 2021 05:45:20 GMT

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.

Re: PROC REPORT by different groups for summation

Ksharp — Sun, 10 Jan 2021 10:41:23 GMT

proc report data=sashelp.cars nowd;
column origin invoice;
define origin/group;
define invoice/analysis sum;
title 'invoice';
run;

topic PROC REPORT by different groups for summation in SAS Programming

PROC REPORT by different groups for summation

Re: PROC REPORT by different groups for summation