Help using Base SAS procedures

Optmodel create data with multiple key-column and different columns

Reply
New User
Posts: 1

Optmodel create data with multiple key-column and different columns

I have a vector X which from 3 sets [Origin, Destination, Product] has a value, and i want to create a table that has as key columns Origin and destination and then for every product a column saying how much to transport.

So something like:

Origin Dest. ProductA ProductB...

A.........AB.......10......0

A.........AC.......5.......4

I'm trying something like this, in optmodel:

 

 

create data Ctrl3.Transport
    from  [Origin Destination] = {FAB, CITIES}
    {k in PRODUCT} <col('Product_'||k) = X[Origin, Destination, k]>; run;

I have another one with 4 variables that doesn't work. Sas doesn't seem to like it

 

But sas doesn't seem to like it

Super User
Posts: 10,538

Re: Optmodel create data with multiple key-column and different columns

You should post details of the project that doesn't work; the code and the log with any error or warning messages.

 

It may also be that the proposed problem has no feasible solutions.

Ask a Question
Discussion stats
  • 1 reply
  • 228 views
  • 0 likes
  • 2 in conversation