SAS BASE

[rimal6_netscape_net]

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

     ....

[Tom · Accepted solution]

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

[rimal6_netscape_net]

Thank you,

             Exactly what I wanted.

Regards

Mahesh