data questions in SAS/OR

YH — Wed, 14 Jan 2015 22:48:44 GMT

Hi everyone,

I have a problem when I was developing an optimization model.

I have a data set in hand which has four columns: ID, frt_val, mid_val and bck_val, and I want to create another data set which is the parameters table for the optimization problem. The length of the parameters table can dynamically change based on number of &Vol. Suppose we set %let Vol = 8; how can I create a table which has &Vol + 1 columns (one for ID), such that the second column stores value of frt_val, the last column stores value of bck_val, and values from columns 3 to 7 are equivalent to mid_val?

Thank you a lot for your help!

YH Fung

As an example:

table 1:

ID frt_val mid_val bck_val

101 100 99 109

102 -10 20 -9

... ... ... ...

how can I create table 2 as following?

table 2:

ID vol1 vol2 vol3 vol4 vol5 vol6 vol7 vol8

101 100 99 99 99 99 99 99 109

102 -10 20 20 20 20 20 20 -9

... ... ... ... ... ... ... ... ...

Re: data questions in SAS/OR

RobPratt — Wed, 14 Jan 2015 22:59:24 GMT

Here's one way:

data want(keep=ID vol:);

set have;

array vol[&Vol];

vol1 = frt_val;

do j = 2 to &Vol-1;

vol = mid_val;

end;

vol&Vol = bck_val;

run;

Re: data questions in SAS/OR

YH — Wed, 14 Jan 2015 23:04:10 GMT

Hi RobPratt,

It works! Thank you so much for your help!

YH Fung

Re: data questions in SAS/OR

RobPratt — Wed, 14 Jan 2015 23:06:26 GMT

Glad to help. Please mark this question Answered.

topic Re: data questions in SAS/OR in Mathematical Optimization, Discrete-Event Simulation, and OR

data questions in SAS/OR

Re: data questions in SAS/OR

Re: data questions in SAS/OR

Re: data questions in SAS/OR