Operations Research topics: SAS/OR,
SAS Optimization, and SAS Simulation Studio

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

Reply
N/A
Posts: 0

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

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
SAS Employee
Posts: 32

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

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
Ask a Question
Discussion stats
  • 1 reply
  • 227 views
  • 0 likes
  • 2 in conversation