topic Re: sum of column in SAS Programming

sum of column

Vijay77 — Thu, 19 Sep 2019 14:22:16 GMT

i have 3 obs like below i want sum of all 3 in 4th obs

1) 2 (40.0)
2) 1 (20.0)
3) 2 (40.0)

4) 8(100)

Re: sum of column

PaigeMiller — Thu, 19 Sep 2019 14:23:28 GMT

@Vijay77 wrote:

i have 3 obs like below i want sum of all 3 in 4th obs

1) 2 (40.0)
2) 1 (20.0)
3) 2 (40.0)

4) 8(100)

How do you get an 8 in the fourth observation?

Re: sum of column

Vijay77 — Thu, 19 Sep 2019 14:57:57 GMT

apologies its 7

Re: sum of column

PaigeMiller — Thu, 19 Sep 2019 15:00:01 GMT

@Vijay77 wrote:

apologies its 7

I don't understand how you obtain the number 7. Please explain.

Re: sum of column

Reeza — Thu, 19 Sep 2019 15:03:43 GMT

In a data set?

data want;
set have end = eof;

retain total;

total + varName;

output;

if eof then do;
varName = total;
output;
end;

drop total;
run;

In a report?

proc print data=have;
var varName;
sum varName;
run;

@Vijay77 wrote:

i have 3 obs like below i want sum of all 3 in 4th obs

1) 2 (40.0)
2) 1 (20.0)
3) 2 (40.0)

4) 8(100)

Re: sum of column

Vijay77 — Fri, 20 Sep 2019 06:36:49 GMT

Re: sum of column

gamotte — Fri, 20 Sep 2019 08:06:19 GMT

hello,

It helps to provide have and want datasets in the form of data steps so we know exactly the type

of data you are dealing with.

If your observations are strings in the form you give in your example, you have

first to extract numbers, for instance with scan and input functions, then you can perform the

summations :

data have;
    input x $10.;
    cards;
2 (40.0)
1 (20.0)
2 (40.0)
;
run;

data want;
    set have end=fend;
    drop sum1 sum2;

    sum1+input(scan(x,1), best.);
    sum2+input(scan(x,2, '()'), best.);

    output;

    if fend then do;
        x=cat(sum1,' (',put(sum2,5.1),')');
        output;
    end;
run;