How to add "Total" to the table

[NazaninSAS]

I'm also going to try ProcSummary.

would you please guide me to a good source for PROCSummary?

Thanks,

Nazanin

[PaigeMiller]

The only source I know of is the SAS documentation at:

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=proc&docsetTarget=p0aq3hsvflz...

There are examples in the PROC MEANS documentation which should work identically in PROC SUMMARY (but I haven't tested them in PROC SUMMARY)

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=proc&docsetTarget=p0f0fjpjeuc...

The only quirk you might want to know is that PROC SUMMARY puts the totals at the top of the output data set, whereas you want them at the bottom, but you can do a sort BY DESCENDING _TYPE_; and then the totals are at the bottom.