topic Re: How can I calculate continuous multiplication in SAS Programming

How can I calculate continuous multiplication

yuwentaiwan — Fri, 29 May 2020 09:08:37 GMT

Obs p

1 1

2 1

3 1.2

4 1

5 1.3

6 1

7 1

8 1.5

I want to this output,how can I calculate continuous multiplication?

Thanks!

Obs p cump

1 1 1

2 1 1(=1*1)

3 1.2 1.2(=1.2*1)

4 1 1.2(=1*1.2)

5 1.3 1.56(=1.3*1.2)

6 1 1.56

7 1 1.56

8 1.5 2.34(1.5*1.56)

ed_sas_member — Fri, 29 May 2020 09:16:48 GMT

Please try this:

data have;
	input Obs p;
	datalines;
1 1
2 1
3 1.2
4 1
5 1.3
6 1
7 1
8 1.5
;
run;

data want;
	set have;
	retain cump 1;
	cump = cump*p;
run;

yuwentaiwan — Fri, 29 May 2020 09:30:36 GMT

Thanks!!:)

ed_sas_member — Fri, 29 May 2020 09:33:11 GMT

You're welcome @yuwentaiwan !