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-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

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
  • 953 views
  • 0 likes
  • 2 in conversation