topic Re: Solving Mixed Integer Non linear programming problem in SAS in Mathematical Optimization, Discrete-Event Simulation, and OR

Solving Mixed Integer Non linear programming problem in SAS

gupta_shubham — Wed, 20 Dec 2017 17:08:02 GMT

Hi,

I want to solve Mixed Integer Non Linear programming problem. I want to know what all options are available in SAS Proc. Optlso can solve MINLP but I am not sure how efficient and accurate it is for bigger problem with hundreds of constraint and thousands variables.

Thanks in advance for our help.

Re: Solving Mixed Integer Non linear programming problem in SAS

RobPratt — Wed, 20 Dec 2017 17:26:24 GMT

Currently, the only direct approaches for MINLP in SAS are to use either PROC OPTLSO or the LSO solver in PROC OPTMODEL, which was just released last week with SAS Optimization 8.2 in SAS Viya 3.3.

But I have personally applied over two dozen indirect approaches that use the other solvers. For example, some problems can be linearized, either exactly or approximately, so that you can use the MILP solver. If you supply more details about your problem, I might be able to provide some recommendations.

Re: Solving Mixed Integer Non linear programming problem in SAS

gupta_shubham — Wed, 20 Dec 2017 18:10:09 GMT

Thanks for your reply.

Solving the approximate problem in fallback solution for me. Problem involves maximizing the revenue (Demand*Price) where Price is variable and D=D0*(1-cdf(price)). I can make demand function linear but since revenue is Demand*Price therefore objective function would still be quadratic.

Do you know how efficient and accurate is PROC OPTLSO ? Is it recommended to solve a big optimization problem with PROC OPTLSO ?

Re: Solving Mixed Integer Non linear programming problem in SAS

RobPratt — Wed, 20 Dec 2017 19:09:28 GMT

The LSO documentation contains this statement in the Overview section:

"As a rule of thumb, derivative-free algorithms are rarely applied to black-box optimization problems that have more than 100 variables."

But there is no hard limit on the number of variables.

What are the integer variables in your problem?

Re: Solving Mixed Integer Non linear programming problem in SAS

gupta_shubham — Wed, 20 Dec 2017 19:11:30 GMT

I want Demand to be integer. So D0*(1-cdf(p)) should be integer

Re: Solving Mixed Integer Non linear programming problem in SAS

RobPratt — Wed, 20 Dec 2017 19:14:34 GMT

Is D0 a constant or a variable?

What is the order of magnitude of demand?

What do the constraints look like?

Re: Solving Mixed Integer Non linear programming problem in SAS

gupta_shubham — Wed, 20 Dec 2017 19:16:04 GMT

D0 is constant. Order of Magnitude is 10^2

Re: Solving Mixed Integer Non linear programming problem in SAS

RobPratt — Wed, 20 Dec 2017 19:28:02 GMT

Do you have PROC OPTMODEL code that you can share?

Re: Solving Mixed Integer Non linear programming problem in SAS

baralamit0 — Wed, 03 Jan 2018 07:00:44 GMT

What is your exact problem ?

Please share.