topic Re: proc optmodel save output in a dataset in Mathematical Optimization, Discrete-Event Simulation, and OR

proc optmodel save output in a dataset

georgel — Mon, 30 Oct 2023 16:54:10 GMT

Dear SAS users:

I would like to have an output dataset using id AT ATvol

cofor {i in row} do;
        id = i;

        solve;
        
        /* Save each individual solution */
          ATsol[id] = AT.sol;
         AT_Volsol[id] = AT_vol.sol;
    if id=1 then do;  
	create data solutionAT from  AT.sol;
	create data solutionATVol from  AT_vol.sol;
    end;

    if id>1 then do;  
	create data solutionAT_temp from  AT.sol;
	create data solutionATVol_temp from  AT_vol.sol;
    end;

This is an extract from proc optmodel: I tried to have data step and append functions but this does not work.

I would appreciate your help

Many thanks

Best regards,

George

Re: proc optmodel save output in a dataset

georgel — Mon, 30 Oct 2023 17:08:49 GMT

https://communities.sas.com/t5/Mathematical-Optimization/Appending-to-a-Dataset-in-Optmodel/td-p/470078

Re: proc optmodel save output in a dataset

RobPratt — Tue, 31 Oct 2023 00:58:44 GMT

   num ATsol {row};
   num AT_Volsol {row};

   cofor {i in row} do;
      id = i;

      solve;

      /* Save each individual solution */
      ATsol[id] = AT.sol;
      AT_Volsol[id] = AT_vol.sol;
   end;

   create data solutionAT from [i] ATsol;
   create data solutionATVol from [i] AT_Volsol;