BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Santha
Pyrite | Level 9

Hi Rob.

I am trying to use sparse modeling as suggested by you few months back. https://go.documentation.sas.com/?docsetId=ormpug&docsetTarget=ormpug_optmodel_examples07.htm&docset...

 

Here is my code. I want to pick p number of facilites that satisfy my customer demand. The following code is an adapted version of the code that you had earlier but the only thing is that I added the CUSTOMERS_SITES to cull out those customers_facilities pairs that has less than 1000 miles as the distance. When I ran the model, I got error that said " A set expression may not depend on a variable". That was my first question. Second question is if my objective function and constraints are right. 

 

proc optmodel;
set DIMS=1..2;
set CUSTOMERS;
set FACILITIES = 1..&p;
num a {CUSTOMERS,DIMS};
num demand {CUSTOMERS};

 

read data STDOPT.COGMODELINGDATA into CUSTOMERS=
[_N_] {d in DIMS} <a[_N_,d]=col('a'||d)> demand;


num Xlb {d in DIMS} = min {i in CUSTOMERS} a[i,d];
num Xub {d in DIMS} = max {i in CUSTOMERS} a[i,d];
print Xlb; print Xub;
var X {FACILITIES, d in DIMS} >= Xlb[d] <= Xub[d];
var W {CUSTOMERS, FACILITIES} >= 0;

impvar Distance {i in CUSTOMERS, j in FACILITIES} = GEODIST(a[i,1],a[i,2],X[j,1],X[j,2]);

set CUSTOMERS_SITES = {i in CUSTOMERS, j in FACILITIES: Distance[i,j] <= 1000};


min Z = sum {<i,j>i in CUSTOMER_SITES} W[i,j]*Distance[i,j];
con DemandCon {i in CUSTOMERS}: sum {j in FACILITIES} W[i,j] = demand[i];

expand;

solve with nlp ;

1 ACCEPTED SOLUTION

Accepted Solutions
RobPratt
SAS Super FREQ

Infeasibility is essentially 0 here, so all constraints are satisfied within tolerance.  Iteration Limit Reached means that the solution might not be locally optimal.  Multisource Weber is a difficult problem, so you might consider solving it approximately by first solving a p-median problem (MILP) with the customers as the candidate locations and then solving a single-source Weber problem for each resulting cluster (p independent NLP problems).

View solution in original post

10 REPLIES 10
RobPratt
SAS Super FREQ

The ERROR message is because your set CUSTOMERS_SITES depends on Distance, which is an implicit variable.  Sets must depend on constants and not variables.

 

It looks like you are mixing two related facility location problems.  For both of them, the input includes a set of customers, each of whose demand must be satisfied by a fixed number (p) of facilities.  The difference between the two problems is where the facilities can be built:

  1. If the facilities can be built anywhere, this is an NLP problem (the multisource Weber problem).
  2. If the facilities must be built at locations that are chosen from among a finite set of candidate sites, this is a MILP problem (the p-median problem).

The sparse modeling approach applies only to the MILP problem.  Which problem do you want to solve?

Santha
Pyrite | Level 9

Hi Rob

Thank you very much. I am trying to solve multi source Weber problem. Can i then, just add a constraint saying someghing like

con radius {i in CUSTOMERS, j in FACILITIES} Distance [i,j]<=1000;?

 

RobPratt
SAS Super FREQ

Yes, that is legal if you include a colon:

con radius {i in CUSTOMERS, j in FACILITIES}: Distance [i,j]<=1000;

But I suspect that these additional nonlinear constraints will make the problem much harder to solve.

Santha
Pyrite | Level 9

Rob. I tried that con radius even  before i was experimenting sparse modeling without knowing that sparse modeling was for MILP. 

The con radius constraint  con radius {i in CUSTOMERS, j in FACILITIES}: Distance [i,j] <=1000;

does not give any error. But it also does not seems to respect the constraint because in the answer I do see some customer-Facility site pairs that have more than 1000 mile as distance. 

RobPratt
SAS Super FREQ

What were the values of Solution Status and Infeasibility in the Solution Summary when you were seeing constraint violations?

Santha
Pyrite | Level 9

Rob - Solution Status is "Failed" as you can see in the below Solution Summary

Solution Summary SolverNLP

Algorithm    Interior Point

Objective Function Z

Solution Status Failed

Objective Value 3796957.4976 

Optimality Error 1394.3093905

Infeasibility702.52192689  

Iterations  2245

Presolve Time 0.00

Solution Time 9.44

Santha
Pyrite | Level 9

When i don't have that con radius, the solution status is "Iteration Limit Reached".

Solver NLP

Algorithm Interior Point

Objective Function Z

Solution Status Iteration Limit Reached

Objective Value 1675638.2436  

Optimality Error 0.1991496343

Infeasibility 2.5283975E-7  

Iterations 5000

Presolve Time 0.00

Solution Time 18.67

 

RobPratt
SAS Super FREQ

Infeasibility is essentially 0 here, so all constraints are satisfied within tolerance.  Iteration Limit Reached means that the solution might not be locally optimal.  Multisource Weber is a difficult problem, so you might consider solving it approximately by first solving a p-median problem (MILP) with the customers as the candidate locations and then solving a single-source Weber problem for each resulting cluster (p independent NLP problems).

Santha
Pyrite | Level 9

Rob 

Thank you very much for your feeback. Let me try to implement that and get back to you. Thanks

RobPratt
SAS Super FREQ

Yes, Infeasibility > 0 implies that some constraints are violated.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 10 replies
  • 1280 views
  • 0 likes
  • 2 in conversation