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

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 1593 views
  • 0 likes
  • 3 in conversation