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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 1 reply
  • 1313 views
  • 0 likes
  • 2 in conversation