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!
As an example:
ID frt_val mid_val bck_val
101 100 99 109
102 -10 20 -9
... ... ... ...
how can I create table 2 as following?
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
... ... ... ... ... ... ... ... ...
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.