I am relatively new with PROC LP. I am trying to run optimizations for a set of units across time. I.e, I want to know which units are efficient in time t, t+1, t+2, etc., to see how the efficiencies and units change over time. Noting that the input dataset needs to be in a text format, plus realizing that I want to try different inputs and outputs to the model, I am looking at developing far too many text files for my liking. Is there any way to use a SAS dataset as an input dataset for the PROC LP procedure, allowing me to set up a loop structure to rerun the model for each time period? Any help would be great.
I assume you want to solve a linear or (mixed-)integer programming problem. PROC LP is a legacy proc, the current procs for this purpose are OPTMODEL, OPTLP and OPTMILP. Specifically for what you describe, OPTMODEL is probably the best choice. Here a link to the documentation (SAS/OR 12.1, but OPTMODEL is available since quite a few versions):
I don't quite understand the details of you question, but with a basic understanding of modeling optimization problems you should be able to state the model for your optimization problem independently from the data files and OPTMODEL also supports loops.
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.