BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Does anybody has a SAS macro, that equivalent to Solver in Excel?
3 REPLIES 3
SAS provides a full-fledged modeling language in proc OPTMODEL. Since Excel's solver is designed for spreadsheet use, there is no equivalent macro in the SAS environment. However, modeling language are far more powerful than spreadsheet-based optimization. You can find more information about proc OPTMODEL in the documentation.
deleted_user
Not applicable
1. No doubt, SAS is more powerfull tool.
2. I could not find proc optmodel in SAS 4.2.
3. Does anybody has a SAS code that does similar things to Excel Solver
Matthew_Galati
SAS Employee
OPTMODEL was first released as part of SAS/OR in SAS 9.1.3.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1693 views
  • 0 likes
  • 3 in conversation