How to get data from e.g. an Excel file into a vector

[BjarneGjerde]

How to get these example data from e.g. an Excel file (or ascii file):  

Var c1 c2

A     2    5

B     4    3

C     6    7

Into the vectors c1 and c2 in the below program.

Proc optmodel;

set box={"A","B","C"};

var Q{i in box} >=0;

number c1{i in box}=[2 4 6];

number c2{i in box}=[5 3 7];

etc. 

quit;

[Ksharp]

Calling @RobPratt

[RobPratt]

First convert to a SAS data set, say indata, by using PROC IMPORT or a DATA _null_ step.  Then use the READ DATA statement:

Proc optmodel;
   set <str> box;
   var Q{box} >=0;
   number c1{box};
   number c2{box};
   read data indata into box=[Var] c1 c2;
   print c1 c2;
quit;

PROC OPTMODEL questions will get more immediate response in the Mathematical Optimization, Discrete-Event Simulation, and OR community.

[BjarneGjerde]

Thanks a lot!

But I do  not see how to get each line or Product (Var A, B, C) – into e.g. c1 {i in box}.  

Proc optmodel;

set box={"A","B","C"};

var Q{i in box} >=0;

number c1{i in box}=[2 4 6];

number c2{i in box}=[5 3 7];

[RobPratt]

The READ DATA statement populates box, c1, and c2 for you.  That way, you can solve a different instance of the same problem just by changing data sets without having to change your PROC OPTMODEL code.