I´m using SAS/OR "proc nlp" and I need to insert data from a huge table
into the proc nlp, this table contain parameters that will be used in
the optimization. I´m trying to use the option "inest", with _TYPE_ = "PARMS",
but this solution is not feasible because the line "PARMS" would need many
variables (or columns) to alocate all the parameters.
Is there any solution? Other way I conclude proc nlp does not support large
amount of data.
Thanks a lot,
I know that you've already received much of this information from our great SAS Technical Support team but I'll repeat it for the benefit of other forum participants. In your case you'd want to use the DATA= option of PROC NLP to import the data on parameters. However you'll still face the challenge of building and using a SAS data set with millions of variables. Fortunately there's a better way. PROC OPTMODEL is our new "flagship" procedure for linear, mixed-integer, quadratic, *and* general nonlinear optimization. Due to OPTMODEL's much greater flexibility in working with input data you should be able to use many observations rather than many variables to specify parameter values in a SAS data set. OPTMODEL delivers many other benefits vs. PROC NLP as well, including far greater clarity in its model-building syntax, improved and updated solvers, and greater flexibility in working with the results of the optimization process.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.