Help using Base SAS procedures

SAS BASE

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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
Super User
Posts: 6,499

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_) (Smiley Happy;

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

View solution in original post


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

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_) (Smiley Happy;

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 206 views
  • 0 likes
  • 2 in conversation