SAS query

[scb]

pct and totalpct are in format percent

I have the following dataset

id        report    pct

434     ABC      30

145     CBD      29

156     1ABN     31

171     gdhd      10

I would like to have the cumulative total for pct as below

id        report    pct   totalpct

434     ABC      30    30

145     CBD      29    59

156     1ABN     31    90

171     gdhd      10    100

Can anyone help? thank you.

[PGStats · Accepted solution]

data want;

set have;

totalpct + pct;

run;

[LinusH]

If you have access to the original data, PROC FREQ has cumulative pct AOTB.
Otherwise define totalpct with a RETAIN statement in a data step, and just add with pct.

[jaatin77]

data have;
input id report $ pct ;
tpct+pct;
datalines;
434 ABC 30
145 CBD 29
156 1ABN 31
171 gdhd 10
;
run;