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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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