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 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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