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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.