Operations Research topics: SAS/OR,
SAS Optimization, and SAS Simulation Studio

Can I use proc OPTMODEL to solve my problem...?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

Can I use proc OPTMODEL to solve my problem...?

I am trying to solve the following...

W = pX

X is an i x 1 vector of known values (i is the number of observations in my sample)

p is a constant and is negative (it is unknown).

W is an i x1 vector of unknown values.

The sum of the values in W needs to equal zero. (w1 + w2 + w3 + ...+ wi = 0)

I am trying to solve for W.

I am not sure how to set up this problem so that I can solve for W.

Is this something that I can do using proc OPTMODEL?

If so, can you please help show me how I can set it up?

If not, can you please recommend an alternative that might work?

I know that I am asking a lot but I have been struggling with this all day and any help or advice is appreciated!

I have tried using the documentation, but I am unsure of how to set up the constraints (the sum of w's is zero and that p is negative constant).


Accepted Solutions
Solution
‎03-30-2015 10:26 AM
SAS Employee
Posts: 448

Re: Can I use proc OPTMODEL to solve my problem...?

Yes, you can do this using PROC OPTMODEL.

If you have declared W as:

var W {1..i};

You can express the constraint that W sums to zero as follows:

con SumToZero:

     sum {j in 1..i} W = 0;

To make p negative, include a slightly negative upper bound in the variable declaration:

var p <= -1e-6;

View solution in original post


All Replies
Solution
‎03-30-2015 10:26 AM
SAS Employee
Posts: 448

Re: Can I use proc OPTMODEL to solve my problem...?

Yes, you can do this using PROC OPTMODEL.

If you have declared W as:

var W {1..i};

You can express the constraint that W sums to zero as follows:

con SumToZero:

     sum {j in 1..i} W = 0;

To make p negative, include a slightly negative upper bound in the variable declaration:

var p <= -1e-6;

Occasional Contributor
Posts: 7

Re: Can I use proc OPTMODEL to solve my problem...?

Thanks Rob,

This is very helpful.

J

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 316 views
  • 0 likes
  • 2 in conversation