BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
RobPratt
SAS Super FREQ

Are you able to share the data?

 

One way to speed things up might be to exclude customer-facility pairs that are too far apart.  The most efficient way to do this is to use sparse modeling to omit the corresponding variables, as illustrated in the Sparse Modeling example in the documentation.

Santha
Pyrite | Level 9

here is the data. thank you

let me look at sparse modeling as well. 

Santha
Pyrite | Level 9

Hi Rob.

Were u able to see what was the problem in the data? I noticed that the MAXTIME of 600 seconds does not seem to be respected as it tries to solve more than that and would never finish. Not sure if something inherently problematic with dataset or sthg.

I am going to try to do sparse modeling today. But if you can let me know about anything to speed the solve it would be great. 

 

RobPratt
SAS Super FREQ

I don't see anything wrong with the data.  Can you please show the SOLVE statement you used, with the MAXTIME= option?

Santha
Pyrite | Level 9

Rob

Here you go. 

solve with nlp / ms feastol=1E-01 maxtime=600 timetype=real;

 

 

RobPratt
SAS Super FREQ

The MAXTIME=600 option that you specified limits each local solver call to 600 seconds.  If you want to limit the overall multistart time, use the MAXTIME= suboption inside the MS= option.  As mentioned in the NLP solver documentation:

"Because the local solver might be called many times, the maximum time that is specified for multistart is recommended to be greater than the maximum time specified for the local solver."

For example:

   solve with nlp / ms=(maxtime=600) feastol=1E-01 maxtime=120 timetype=real;
Santha
Pyrite | Level 9

oh ok. got it. thanks . it worked fine now

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 21 replies
  • 1470 views
  • 6 likes
  • 2 in conversation