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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.