BookmarkSubscribeRSS Feed
AB
Calcite | Level 5 AB
Calcite | Level 5
I am trying to set constraints around a forecasted balance amount but when I try to test setting some constraints, it doesn't seem to match the vector being printed. For example, when I print the vector, I get a 51.9 billion number... [1] portfolio_end_bl_data 1 51909185434 But when I set the below constraint, it returns a solution status of Infeasible... Constraint mon_bal_c1[1]: 51000000000 <= portfolio_end_bl_data[1] <= 52000000000 When I change it to the below, it returns a status of Optimal... Constraint mon_bal_c1[1]: 52000000000 <= portfolio_end_bl_data[1] <= 53000000000 Any ideas would be appreciated.
3 REPLIES 3
RobPratt
SAS Super FREQ

Please post complete code and data, and I'll take a look.

AB
Calcite | Level 5 AB
Calcite | Level 5

The optmodel code is fairly extensive (over 10k lines) and there are 20+ datasets, both of which I couldn't share on a public forum - was hoping there was maybe something common conceptually to try or options to look at. I'm using solve with nlp. Or let me know if there's another way to handle this without posting the full logic. Appreciate it!

RobPratt
SAS Super FREQ

That number of lines is quite unusual, and I suspect that you aren't exploiting the full capabilities of PROC OPTMODEL, which provides a very expressive modeling language that typically requires at most hundreds of lines even for complicated user-customized algorithms that call multiple solvers.  It is hard to recommend anything specific without seeing more detail.  Perhaps it would be best to submit your code and log to technical support, and I'll take a look.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Multiple Linear Regression in SAS

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.

Discussion stats
  • 3 replies
  • 1207 views
  • 0 likes
  • 2 in conversation