Hello,
How do I Calculate Product on each level?
Data like this
t d y Prod (1-d/y)
6 3 21 (1-3/21)
7 1 17 (1-3/21)(1-1/17) and so on...
10 1 15
13 1 12
16 1 11
22 1 7
23 1 6
....
Is this what you want?
data want ;
input t d y ;
retain prod 1 ;
prod = prod*(1-d/y);
cards;
6 3 21 (1-3/21)
7 1 17 (1-3/21)(1-1/17) and so on...
10 1 15
13 1 12
16 1 11
22 1 7
23 1 6
;;;;
data _null_;
set ;
put (_all_) (:);
run;
6 3 21 0.8571428571
7 1 17 0.8067226891
10 1 15 0.7529411765
13 1 12 0.6901960784
16 1 11 0.6274509804
22 1 7 0.5378151261
23 1 6 0.4481792717
Is this what you want?
data want ;
input t d y ;
retain prod 1 ;
prod = prod*(1-d/y);
cards;
6 3 21 (1-3/21)
7 1 17 (1-3/21)(1-1/17) and so on...
10 1 15
13 1 12
16 1 11
22 1 7
23 1 6
;;;;
data _null_;
set ;
put (_all_) (:);
run;
6 3 21 0.8571428571
7 1 17 0.8067226891
10 1 15 0.7529411765
13 1 12 0.6901960784
16 1 11 0.6274509804
22 1 7 0.5378151261
23 1 6 0.4481792717
Thank you,
Exactly what I wanted.
Regards
Mahesh
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.