So, the parts of your attachment highlighted in yellow make no sense to me, and explanation is not provided. Which means to me that before we could provide any real assistance, these issues would have to be cleared up and explained.
I also think that PROC IML would be able to handle this type of calculation easily.
Also, it should be mentioned that at least a partial solution to this problem has been provided in your previous thread.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.