BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sasworker16
Calcite | Level 5

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.

 

 

 

 

 

1 ACCEPTED SOLUTION

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

View solution in original post

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 805 views
  • 1 like
  • 2 in conversation