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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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