Hi,
I am trying to formulate this in SAS:
How should i code this?
Your formula has a couple of issues, including overloading of t. I assume you meant the following (in LaTeX notation):
\sum_j j x_{ijt} = \sum_{s=\max(1,t-8)}^t y_{is} + \sum_{s=\max(1,t-16)}^t z_{is} + \sum_{s=\max(1,t-24)}^t w_{is} \forall i,t
If so, you can write this constraint in PROC OPTMODEL as follows:
con Mycon {i in ISET, t in TSET}:
sum {j in JSET} j * x[i,j,t] = sum {s in max(1,t-8)..t} y[i,s] + sum {s in max(1,t-16)..t} z[i,s] + sum {s in max(1,t-24)..t} w[i,s];
Hi Rob,
Thanks for your help. I will give it a try.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.