topic Re: How to convert "mps standard format" to "mps sas data set" from a table ? in Mathematical Optimization, Discrete-Event Simulation, and OR

How to convert "mps standard format" to "mps sas data set" from a table ?

deleted_user — Thu, 10 Feb 2011 16:39:55 GMT

Hello,

I have lp problems in mps standard (respectively free) format in a table of my databank.
Is it possible to use PROC SQL to select and convert them to mps sas data set, so that I can Input into PROC OPTMILP?

As sparsedata I can seclect a problem form my databank into a table with PROC SQL and convert it with PROC LP:
proc lp data=exdata mpsout=mpsdata;
run;

But for mps format, I find only the macro %mps2sasd in the user's guide. Its parameter must be a file (.mps).

Thanks

Re: How to convert "mps standard format" to "mps sas data set" from a table ?

Philipp_SAS — Fri, 11 Feb 2011 15:02:34 GMT

Hi Chavalit,

Unfortunately there is no auto macro to read an MPS data set from a database. But since the data set format is almost the same as the mps format, it should not be hard to write a macro for it using PROC SQL.

Here is some information about the mps data set format:
http://support.sas.com/documentation/cdl/en/ormpug/63352/HTML/default/viewer.htm#mpsds_toc.htm

Have a great day
Philipp