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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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