🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Calcite | Level 5

## 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).

1 ACCEPTED SOLUTION

Accepted Solutions
SAS Super FREQ

## 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;

2 REPLIES 2
SAS Super FREQ

## 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;

Calcite | Level 5

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

Thanks Rob,

This is very helpful.

J

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