Regarding your link, I never (and many people never) download and open MS Office files, as they can be a security risk. So I can't see your data.
The details provided at that link are not sufficient for me to determine what other types of coding might work. Since you say you want to minimize the sum of squares of errors, what method is being used to do this? Can you be specific? SAS has this capability in some areas.
To minimize the sum square error, we calculate the predicted values using a index value (formula for calculation of this predicted value is NORM.S.DIST(index value + zscore)) , the index value in the formula can be any random value such that the sum square error is minimum between the actual values and predicted values. Hope I am able to explain, else let me know some other way if I can share the dummy data with you.
Sounds like some type of regression. Is it?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.