topic Re: what is the best way to create a new variable with sum in SAS Programming

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

vraj1 — Fri, 02 Sep 2016 08:40:04 GMT

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

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

LinusH — Fri, 02 Sep 2016 09:00:56 GMT

PROC PRINT.

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

set_all__ — Fri, 02 Sep 2016 13:53:18 GMT

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;

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

ballardw — Fri, 02 Sep 2016 15:27:07 GMT

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.