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

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;

 

1 ACCEPTED SOLUTION

Accepted Solutions
RobPratt
SAS Super FREQ

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.

View solution in original post

1 REPLY 1
RobPratt
SAS Super FREQ

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.