topic Re: Read Data OPTMODEL with calculation in Mathematical Optimization, Discrete-Event Simulation, and OR

Read Data OPTMODEL with calculation

Santha — Tue, 10 Mar 2020 19:11:26 GMT

When using optmodel and using read data can i do calculation. like i want to take 10% of the value "FEU" and store in this number GIC_Min. Not sure if i can do that. I did that and got error.

num GIC_Min;

READ DATA STDOPT.PN3158_specifics INTO GIC_Min=0.1*[FEU];

Re: Read Data OPTMODEL with calculation

RobPratt — Tue, 10 Mar 2020 20:15:16 GMT

No, you cannot do that. You need an explicit assignment statement after the READ DATA statement, as demonstrated in these two documentation examples:

With CREATE DATA, you can perform calculations if you use parentheses around the expression, as shown in the documentation here.

Re: Read Data OPTMODEL with calculation

Santha — Tue, 10 Mar 2020 20:22:10 GMT

Thanks Rob I will go through those two examples.

I have 4 or 5 questions those are very specific to a constraint. Can i post those as a separate thread (one for each)?

Re: Read Data OPTMODEL with calculation

RobPratt — Tue, 10 Mar 2020 20:32:58 GMT

Yes, please use separate threads for different questions.

Re: Read Data OPTMODEL with calculation

Santha — Tue, 10 Mar 2020 21:12:52 GMT

THe assignment statement in your example did the trick. Awesome Rob! Thank you very much

Re: Read Data OPTMODEL with calculation

Santha — Tue, 10 Mar 2020 22:54:54 GMT

READ DATA STDOPT.PN3158_ALT6_SPECIFICS INTO LAX_Min=FEU

In this read data statement in proc optmodel, I want to read only when the column name in my table "Dest" = "LAX".

How do I specify the condition?

Re: Read Data OPTMODEL with calculation

RobPratt — Wed, 11 Mar 2020 17:13:40 GMT

You can use DATA step options in the READ DATA statement, as documented here.

For your example, it would like this:

READ DATA STDOPT.PN3158_ALT6_SPECIFICS(where=(Dest = "LAX")) INTO LAX_Min=FEU;

Re: Read Data OPTMODEL with calculation

Santha — Wed, 11 Mar 2020 18:04:04 GMT

Awesome. Thanks a lot Rob