Omitting zero values in solution

[nicwoyak]

I am developing a model with proc optmodel and as I go through the process of testing and verifying solution values I am having to go through a very large number of variables, but the solution is sparse with most of them 0. Is there a way to print out the variable without all the 0 values?

For example "print DecisionVariable;" yields:

Set1	Set2	Set3	DecisionVariable
1	1	1	0
1	2	1	1
1	3	1	0
2	1	1	0
2	2	1	0
2	3	1	0
3	1	1	0
3	2	1	0
3	3	1	0

But I would like something that will just result in:

Set1	Set2	Set3	DecisionVariable
1	2	1	1

[RobPratt · Accepted solution]

Here's one way, by using a selection expression in the PRINT statement:

print {i1 in Set1, i2 in Set2, i3 in Set3: DecisionVariable[i1,i2,i3].sol > 0.5} DecisionVariable; 

[nicwoyak]

Thank you so much. I just had to add some contingent clauses based on what my variable had that I hadn't mentioned above after the : (e.g. i1<>i2 etc.) and that worked perfectly.