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