Solved
New Contributor
Posts: 2

# SAS BASE

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

....

Accepted Solutions
Solution
‎02-15-2015 10:38 AM
Super User
Posts: 8,073

## Re: SAS BASE

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

All Replies
Solution
‎02-15-2015 10:38 AM
Super User
Posts: 8,073

## Re: SAS BASE

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

New Contributor
Posts: 2

## Re: SAS BASE

Thank you,

Exactly what I wanted.

Regards

Mahesh

🔒 This topic is solved and locked.