topic Re: How to print output of optmodel into a table in Mathematical Optimization, Discrete-Event Simulation, and OR

How to print output of optmodel into a table

Anirudh9 — Mon, 01 Jul 2019 19:35:22 GMT

My code looks like this:-

proc optmodel;

/*rest of my code */

solve;

print z;

print x;

print y;

When I run this I see the results as a report. I want z, x, y as a SAS table instead. z, x, y

I tried using

optmodel printlevel=2;
   ods output PrintTable=expt ProblemSummary=exps DerivMethods=exdm 
              SolverOptions=exso SolutionSummary=exss OptStatistics=exos;

but it only showed the table for z and not for x and y

Re: How to print output of optmodel into a table

RobPratt — Mon, 01 Jul 2019 19:52:01 GMT

Here are three ways.

1. Use only one PRINT statement:

print z x y;

2. Use three PrintTable= options:

PrintTable=expt PrintTable#2=expt2 PrintTable#3=expt3

3. Omit the ODS statement and instead use CREATE DATA:

create data expt from z x y;

Re: How to print output of optmodel into a table

Anirudh9 — Mon, 01 Jul 2019 19:54:44 GMT

Awesome! I tried option 2, it worked like a charm!