BookmarkSubscribeRSS Feed

Hi All,

 

Does proc optmodel support nonlinear mix integer optimization problem?

 

I have formulated the problem and model in Proc Optmodel. I am getting following error message 

 

 – “ERROR: The NLP solver does not allow integer variables.”

 

thanking in advance

Lokendra

3 REPLIES 3
RobPratt
SAS Super FREQ

PROC OPTMODEL does not (yet) support mixed integer nonlinear optimization, so the error message is expected.  Such problems can often be either linearized or solved indirectly.  Can you please share your data and code?

Thanks for your reply.

A representative expression is 

Demand  = Constant x (RecommendedPrice/FullPrice)^(-1.8) x (CompetitorPrice/FullPrice)^(-1.5)

RecommendedPrice is a decision variable and Revenue = Demand x RecommendedPrice is in the objective function.

We have some logical constraints on RecommendedPrices which we are modeling using binary variables. The actual problem has many products for which we are determining the price and there are relationships among these prices which are either logical (leading to binary variables) or linear.

 

As now we know Proc Optmodel does not support this kind of problem.  We are trying to use Proc OPTLSO.  We are trying to use proc optmodel to generate QPS or MPS data but since this is not quadratic problem and also not a linear problem we get error.  In the support they suggest to use Proc FCMP to produce problem statement and use OPTLSO to solve.  Is there any otherway to get the expanded form of probelm.

 

thanks

Lokendra 

RobPratt
SAS Super FREQ

To use PROC OPTMODEL to generate MPS or QPS, you must remove the nonlinear parts and handle them separately with PROC FCMP, as in this doc example: Example 3.6 Using Nonlinear Constraints

 

Alternatively, what you have shown so far can be linearized by taking logs, with LogDemand and LogRecommendedPrice as your decision variables:

 

LogDemand  = log(Constant) -1.8 (LogRecommendedPrice - log(FullPrice)) -1.5 (log(CompetitorPrice) - log(FullPrice))

 

LogRevenue = LogDemand + LogRecommendedPrice

 

If the full problem can be linearized, you can use the MILP solver in PROC OPTMODEL.  If you provide the full code and data, I'll take a look.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 1588 views
  • 0 likes
  • 2 in conversation