How to print output of optmodel into a table

[Anirudh9]

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

[RobPratt · Accepted solution]

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;

[Anirudh9]

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