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

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

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