How can I calculate continuous multiplication

[yuwentaiwan]

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 · Accepted solution]

Hi @yuwentaiwan 

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]

Thanks!!:)

[ed_sas_member]

You're welcome @yuwentaiwan !