what is the best way to create a new variable with sum

[vraj1]

I have a dataset like

Trial     treat1   treat2

123       23.2      34.2

234       78          87

Now i want a last column naming all with sum of the rows

Trial     treat1   treat2

123       23.2      34.2

234       78          87

all          101,2    121,2

Can any one help me in this

[LinusH]

PROC PRINT.

[set_all__]

proc sql;
create table sum_row as
select
'all' as trial,
sum(treat1) as treat1,
sum(treat2) as treat2
from have;
quit;

proc append base=have data=sum_row;
run;

[ballardw]

I am always very leery of any inserted summary rows inside a data set. What happens if you run the same summary program later on the same data? Or you run a report procedure like Proc Report that generates summary totals. You have now included the summary into a new summary.

At a very minimum I would add an indicator variable to show that the row is indeed some sort of summary and the other rows aren't with appropriate label for the indicator.