topic Re: SAS query in SAS Programming

SAS query

scb — Sat, 09 Apr 2016 21:37:25 GMT

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.

Re: SAS query

PGStats — Sat, 09 Apr 2016 21:54:07 GMT

data want;

set have;

totalpct + pct;

run;

Re: SAS query

LinusH — Sat, 09 Apr 2016 21:56:12 GMT

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.

Re: SAS query

jaatin77 — Sun, 10 Apr 2016 03:23:26 GMT

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