Is it possible in Proc Print to put the sum at top of table?

[CharlesFowler72]

Expecting either a quick and simple answer or a quick and simple no...can you put the sum row as row 1 on the table? Not a big deal but would make my life marginally easier if I could :D.

thank you in advanced.  

[Reeza · Accepted solution]

I don't believe so, but PROC REPORT can do that.

[CharlesFowler72]

What I expected, thanks Reeza.

[novinosrin]

How I wish I saved the very demo by @ballardw in one of his posts for a very similar question using proc tabulate. I will wait if he responds

[Reeza]

PROC TABULATE is relatively easy, just put the ALL before the variable name.

[novinosrin]

is that all? really?

[Reeza]

proc tabulate data=sashelp.class;
class sex;
var age;
table (All='Both Sexes' Sex='') , age*MEAN=''*f=8.1;
run;

All before SEX means the total is at the top. Move all after and it's at the bottom. IN this case I used Mean, but you could replace that with SUM for a different report.

proc tabulate data=sashelp.class;
class sex;
var age;
table (Sex='' All='Both Sexes' ) , age*MEAN=''*f=8.1;
run;

The biggest difference is that PROC TABULATE is a summary procedure, where it summarizes the data. Whereas REPORT and PRINT are more used to display row level information.