BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Obsidian | Level 7

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

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

I don't believe so, but PROC REPORT can do that.
6 REPLIES 6
Super User

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

I don't believe so, but PROC REPORT can do that.
Obsidian | Level 7

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

What I expected, thanks Reeza.
Tourmaline | Level 20

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

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

Super User

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

PROC TABULATE is relatively easy, just put the ALL before the variable name.
Tourmaline | Level 20

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

is that all? really?

Super User

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

``````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.

Discussion stats
• 6 replies
• 676 views
• 6 likes
• 3 in conversation