Hello, Example of data: ID TOTAL_VALUE START_DATE END_DATE 1 1000 15-11-04 17-09-30 2 3000 16-11-29 17-12-15 3 5000 15-12-08 16-01-11 (all dates are in SAS date) I would like to get pro rata transaction value for each year involved. For example, for ID1, the transaction starts in Nov 2015 and ends in Sep 2017. It has 2 months in 2015, 12 months in 2016, and 9 months in 2017. So for 2015, the assigned value = 2/23 * 1000, for 2016, 12/23 * 1000, for 2017, 9/23 * 1000. My desired output: ID YEAR VALUE 1 2015 86.96 1 2016 521.73 1 2017 391.30 2 2016 230.77 2 2017 2769.23 3 2015 2500.00 3 2016 2500.00 Calculation in terms of number of days, or round down to number of months as I have shown in the example are both acceptable. I'm very new to SAS, and I can only think of extracting years from start_date and end_date and then create an array of years out of it. But I can't figure out how to do the prorata part. Any thoughts would help. Thank you!
... View more