topic Re: adding a total (for each column) to a dataset in SAS Programming

adding a total (for each column) to a dataset

gzr2mz39 — Mon, 28 Feb 2011 17:34:49 GMT

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.

Re: adding a total (for each column) to a dataset

RickM — Mon, 28 Feb 2011 17:46:12 GMT

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

Re: adding a total (for each column) to a dataset

gzr2mz39 — Mon, 28 Feb 2011 18:01:34 GMT

Thank you.

Re: adding a total (for each column) to a dataset

Ksharp — Tue, 01 Mar 2011 02:18:53 GMT

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

Ksharp

Re: adding a total (for each column) to a dataset

Peter_C — Wed, 02 Mar 2011 18:17:52 GMT

how about a SUM statement on PROC PRINT ?

Re: adding a total (for each column) to a dataset

gzr2mz39 — Wed, 02 Mar 2011 18:23:59 GMT

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

Re: adding a total (for each column) to a dataset

Ksharp — Thu, 03 Mar 2011 03:30:54 GMT

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

Ksharp