adding a total (for each column) to a dataset

[gzr2mz39]

I have three variables: location, a and b:
location a b
x 1 2
y 1 2

How do I add an observation to the variable location called total where a=2 (1+1) and b=4 (2+2) so that I have:
location a b
x 1 2
y 1 2
total 2 4

Essentially what I want to do is to add an observation named total to the location variable that has the sum of columns a and b.

Thank you.

[RickM]

You could do something like:

data want;
set have end=eof;
c+a;
d+b;
output;
if eof then do;
location="Total";
a=c;
b=d;
output;
end;
drop c d;
run; Message was edited by: RickM

[gzr2mz39]

Thank you.

[Ksharp]

Hi.
Base on this situation, I think proc tabulate and proc report would be best choice.


Ksharp

[Peter_C]

how about a SUM statement on PROC PRINT ?

[gzr2mz39]

RickM posted what I was looking for.
The goal was to incorporate the total (for each column) into the dataset.
Thank you.

[Ksharp]

Hi.
Dear Peter.
Op want ' Total :......' .
I think proc print is difficult to print 'Total' ..


Ksharp