find a vector solution from two constraints

neilxu — Wed, 28 Jun 2017 14:03:30 GMT

Hi All,

I used SAS/OR proc optmodel before in order to find a solution. But that's for a single number.

Now I need to randomly pick 100 records from 1000 records. There is another constaint, the sum of these 100 records must be a ceterain number (K).

So the constaints are: sum of the total number of records is 100 and the sum of records is K.

Where can I start? I look up some of examples but I cannot find anything similar.

Thanks

Re: find a vector solution from two constraints

RobPratt — Wed, 28 Jun 2017 16:37:25 GMT

I think you want to declare a binary variable for each record and then declare your two constraints, like this:

set RECORDS;
num a {RECORDS};
read data indata into RECORDS=[record] a;
var X {RECORDS} binary;
con NumberRecords:
   sum {r in RECORDS} X[r] = 100;
con SumRecords:
   sum {r in RECORDS} a[r]*X[r] = k;

topic Re: find a vector solution from two constraints in Mathematical Optimization, Discrete-Event Simulation, and OR

find a vector solution from two constraints

Re: find a vector solution from two constraints