Creating a set from a data set within optmodel

jfreyes — Wed, 07 Mar 2018 02:27:05 GMT

Hey! (working on SAS Studio)

I am trying to create a set in the proc optmodel body of my program, but so far I haven't been successful.

For small sets is ok to create the sets for variables, parameters in the declaration statement but right now I am working with a problem instance that has 200+ elements in one set and 1300+ in another one, so I wonder if there is a way to create a set from a previous data set I can create beforehand.

Something like this.

Data H;
input ids;
datalines;
131
199
229
512
;
Run;

proc optmodel;
set Hubs;
Read data H into Hubs=ids;

Re: Creating a set from a data set within optmodel

RobPratt — Wed, 07 Mar 2018 02:47:28 GMT

You almost had it. You just need square brackets around the key column(s):

Read data H into Hubs=[ids];

You might find this book of examples useful for learning about PROC OPTMODEL.

topic Re: Creating a set from a data set within optmodel in Mathematical Optimization, Discrete-Event Simulation, and OR

Creating a set from a data set within optmodel

Re: Creating a set from a data set within optmodel