Loading the data works fine -- I see the data correctly with VIEWTABLE.
Trying to run the program gives the following ERROR messages:
ERROR: The coefficient in row EQ_LOW_M and column _RHS_ is defined to be 3000000 and 10000000.
ERROR: The coefficient in row EQ_UPP_M and column _RHS_ is defined to be 3000000 and 17000000.
ERROR: The coefficient in row EQ_LOW_G and column _RHS_ is defined to be 39000000 and 120000000.
I looks as if the names in _ROW1_ (e.g. EQ_LOW_M_75300202_183) are only interpreted with the FIRST 8 CHARACTERS. This does only happen,
when we use SAS interactively with data from files. We use the sparsedata format as above for years now, but read the problem from oracle
with the sql statement:
create table model as select
type as _type_, col as _col_, row1 as _row1_, coef1 as _coef1_,
row2 as _row2_, coef2 as _coef2_, row3 as _row3_, coef3 as _coef3_
from GASOPT.opt_sparsedata where variante_id = &Variante;
There is no problem at all, if I use the "standard" sparsedata format interactively:
The problem might be that in the format you read _ROW2_ and _ROW3_ with $7.. Try changing it to $28. Maybe LP uses the smallest or the last row variable size. You can enter a Tech Support request to have it further investigated.
By the way, OPTMODEL and OPTLP/OPTMILP are much more powerful and more modern procs for doing mathematical programming.
Thank you for your reply. Your guess that "Maybe LP uses the smallest or the last row variable size" was absolutely right: I changed ALL _ROWx_ to $28 format and now it works. You must admit, that this behaviour of PROC LP is a bit strange ...