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?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: