Hi, what i have: I get information for interest levels for one product like this in a dataset1: Productcode Level in EUR Interestrate 123 999.999.999 0,10 123 100.000 0,20 123 50.000 0,30 123 10.000 0,50 this means i pay for the customer 0,50% up to 10.000 EUR between 10000 and 50000 I pay 0,30% and so on. I have another dateset2 with all the contracts and of course also with the Productcode 123. Now I need to now how many volume is within my 4 interest buckets over all the contracts with code 123 so to calculate my avarage interest rate i pay vor the product in total. Example contract1 with balance 75.000 schould end in sum 10000 for the 1st bucket 40000 for the 2nd bucket and 25000 for the 3rd bucket. I think you got the idea. Is there any usefill funktion in SAS Base 9.2 which kan help or do I need to programm a macro up from zero. Thank you for some ideas.
... View more