Proc Report calculate column subtotal from max total

harsh1 — Thu, 13 Sep 2018 12:24:22 GMT

Hello all,

I am trying to calculate sum of subtotal of Total Blends column but my source column is based on max value but actually in subtotal it should show summation of all rows.

Does anyone have any idea?

Regards,

Harsh.

Re: Proc Report calculate column subtotal from max total

ballardw — Thu, 13 Sep 2018 14:42:22 GMT

Since you have a picture of your report there is not really anything gained by attaching a document with the same picture.

It would help to show the code used to create the table that you have so far. That way we at least know what your variable names are and what roles you have assigned them in proc report. Best would be to include a small example of the data in a data step.

topic Proc Report calculate column subtotal from max total in SAS Programming

Proc Report calculate column subtotal from max total

Re: Proc Report calculate column subtotal from max total