Operations Research topics: SAS/OR,
SAS Optimization, and SAS Simulation Studio

data questions in SAS/OR

Accepted Solution Solved
Reply
Occasional Contributor YH
Occasional Contributor
Posts: 10
Accepted Solution

data questions in SAS/OR

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

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


Accepted Solutions
Solution
‎01-14-2015 05:59 PM
SAS Employee
Posts: 447

Re: data questions in SAS/OR

Here's one way:

data want(keep=ID volSmiley Happy;

   set have;

   array vol[&Vol];

   vol1 = frt_val;

   do j = 2 to &Vol-1;

      vol = mid_val;

   end;

   vol&Vol = bck_val;

run;

View solution in original post


All Replies
Solution
‎01-14-2015 05:59 PM
SAS Employee
Posts: 447

Re: data questions in SAS/OR

Here's one way:

data want(keep=ID volSmiley Happy;

   set have;

   array vol[&Vol];

   vol1 = frt_val;

   do j = 2 to &Vol-1;

      vol = mid_val;

   end;

   vol&Vol = bck_val;

run;

Occasional Contributor YH
Occasional Contributor
Posts: 10

Re: data questions in SAS/OR

Hi RobPratt,

It works! Thank you so much for your help!

YH Fung

SAS Employee
Posts: 447

Re: data questions in SAS/OR

Glad to help.  Please mark this question Answered.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 296 views
  • 0 likes
  • 2 in conversation