Help using Base SAS procedures

Yield Calculation

Reply
N/A
Posts: 0

Yield Calculation

I am trying to create a yield calculation that basically finds the yield for a security using 'guess and check'. Right now, in Excel I have 300+ rows of data, and each row gets put through the same calculation, which is driven by yield (the guess and check number). The result of this calculation for each row is then summed together, and compared to a total I have in another sheet. If the summed total, and the total I already have don't match, the process starts all over again. I am trying to automate this process in SAS.

I've tried DO LOOPS, RETURNS, GO TOs all without much effect. Can someone please point me in the right direction, asfar as how to do this calculation in SAS?

Thank you.
Occasional Contributor
Posts: 8

Re: Yield Calculation

Posted in reply to deleted_user
so your sasdata is like:

id yield total
1 20 20
1 30 50
1 40 90
2 25 25
2 12 37

?
N/A
Posts: 0

Re: Yield Calculation

Posted in reply to Stephanie55901
Here's an example that kind of simplifies....

OBS | AMT | FACTOR| CALC
1 | 10 | .5 | 5
2 | 20 | .5 | 10
3 | 20 | .4 | 8
4 | 25 | .4 | 10
5 | 25 | .4 | 10

FACTOR is a calculation that is driven by what the Yield I need is (guess and check). Calc is the result for each row. After the calculation is made, I need to add the CALC numbers to create a total (this case it would be 43) and then compare to a total I already have (let's say 50).

So my calculation grand total is 43, but I need 50, so I would need to run the whole thing again trying another YIELD.
Ask a Question
Discussion stats
  • 2 replies
  • 117 views
  • 0 likes
  • 2 in conversation