Optmodel create data with multiple key-column and different columns

BenjiP — Sat, 28 May 2016 15:01:29 GMT

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

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

ballardw — Tue, 31 May 2016 20:48:34 GMT

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.

topic Optmodel create data with multiple key-column and different columns in SAS Procedures

Optmodel create data with multiple key-column and different columns

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