topic Re: Recognizing one variable, then sum in another row in SAS Procedures

Recognizing one variable, then sum in another row

TMorville — Mon, 15 Nov 2010 10:11:13 GMT

Hi. I have a dataset that looks like this..

Name Value
X 13
X 12
Y 44
X 12
Y 213
Z 12
Y 54

But.. it's with approximatly 2000 different X,Y,Z....

So what i would like SAS to do, is to recognize each specific X, and everytime it does so, add the "Value" variable. X would in this test case be 13+12+12 = 27 - output would thus look like:

Name Value
X 27
Y 311
Z 12

I've tryed to google it, but with no luck.

Any ideas?

Thanks!

Re: Recognizing one variable, then sum in another row

TMorville — Mon, 15 Nov 2010 10:17:18 GMT

I think i just made this work:

proc sql;
create table g as
select
by,
sum(VALUE) as branch_profit
from c
where by ne ' '
group by NAME;
quit; Message was edited by: TMorville

Re: Recognizing one variable, then sum in another row

Peter_C — Mon, 15 Nov 2010 13:30:05 GMT

> Hi. I have a

> variable. X would in this test case be 13+12+12 = 27

challenging 😉

> Any ideas?

proc means
will also provide class totals like
proc means data= whatever nway ;
class name ;
var value ;
output sum= out= summary ;
run ;
proc print ;
id name ;
var value ;
run;