DATA Step, Macro, Functions and more

How to Sum Vertically

Reply
Occasional Contributor
Posts: 5

How to Sum Vertically

I have a data set from SAS. I am trying to make a report that sums the MSRP for each MAKE of sports cars. 

 

I'm not too sure how to do this. 

 

I tried using the pro univariate but I don't know how to format to sum the MSRP for each make. 

 

data sportscars;

     set sashelp.cars;

     if type = 'Sports';

run;

Super User
Posts: 17,907

Re: How to Sum Vertically

Put MAKE in the CLASS or BY statement. 

If you include it in the BY statement the data has to be sorted. In the CLASS statement it does not.

 

Personally, I prefer PROC MEANS.

 

PROC MEANS DATA= sashelp.cars N SUM;

class make;

var MSRP;

output out=want sum(MSRP) = MSRP_TOTAL;

run;

Occasional Contributor
Posts: 5

Re: How to Sum Vertically

Thank you so much!!! I had tried proc means, but I did not format it correctly. 

 

 

Super User
Super User
Posts: 7,413

Re: How to Sum Vertically

Please mark @Reeza's answer as correct.

Ask a Question
Discussion stats
  • 3 replies
  • 183 views
  • 1 like
  • 3 in conversation