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;
... View more