Repeating Calculations

[Season]

Hello, I've read your question and found out that your problem is somehow similar with a problem I encountered a week ago. By then, I was trying to test the normality of a certain variable when grouped by multiple categorical variables. Since the CLASS statement can only put one variable in, I had to repeat PROC UNIVARIATE many times to do this job. The CALL EXECUTE routine perfectly solved my problem. Since your problem is also centered on repetitive work, I think that it might also work for you. See the code in the solution of How should I use SAS macro to perform PROC UNIVARIATE repetitively? for more details. The method was suggested to me by @ballardw. I later made some adjustments to the code and eventually formed the code in the solution. I hope it will be helpful to you.