I have 4 var arrays that have <sku plant tp> as indexed values. Not every <sku plant tp> is in each array. I have a set that has all known <sku plant tp> values that may exist in 1 or more arrays. The sum of these values must be >= to a value in another table for all <sku plant tp> I am running a linear model. I want to sum for all possible values within the 4 arrays together and just assume zero wherever a value does not exist. When I tried to set up a constraint looking across all possible values it failed saying the indexed vars must have all the entries. When I added all the entries to each table but did not compute a value for those I wanted to be zero, optmodel plugged values into those cells to reduce costs, as I had no equation to set those specific values. I then added a constraint so that those missing values I wanted to be zero had to be zero. That fixed my "problem" but my solution time jumped from under 10 minutes to over an hour. That amount of time to solve is not acceptable. Any ideas, thoughts, or suggestions out there that could simplify this process or speed up the solve time would greatly be appreciated. fyi... I am running on SAS Office Analytics 9.4 TS1M8. Thanks. Roger
