topic Re: Is it possible in Proc Print to put the sum at top of table? in SAS Programming

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

CharlesFowler72 — Fri, 12 Oct 2018 16:34:10 GMT

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.

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

Reeza — Fri, 12 Oct 2018 16:59:14 GMT

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

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

CharlesFowler72 — Fri, 12 Oct 2018 17:00:10 GMT

What I expected, thanks Reeza.

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

novinosrin — Fri, 12 Oct 2018 17:01:35 GMT

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

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

Reeza — Fri, 12 Oct 2018 17:04:21 GMT

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

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

novinosrin — Fri, 12 Oct 2018 17:04:54 GMT

is that all? really?

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

Reeza — Fri, 12 Oct 2018 17:08:30 GMT

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.