Optmodel create data with multiple key-column and different columns

[BenjiP]

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

[ballardw]

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.