Business Context
A manufacturing company is migrating an old production planning optimization model from a mainframe system to SAS Viya. The legacy system exports the linear programming problem in the strict 'Fixed' MPS format (specific column alignment). The goal is to ensure the converter correctly parses this rigid format into a usable CAS table for the solver.
Data Preparation
Creation of a CAS table simulating a raw MPS file in 'FIXED' format (strict column positioning).
Copied!
| 1 | DATA casuser.mps_fixed_source; INFILE DATALINES truncover; INPUT id line $char80.; DATALINES; |
| 2 | 1 NAME PROD_MIX |
| 3 | 2 ROWS |
| 4 | 3 N PROFIT |
| 5 | 4 L MACHINE_A |
| 6 | 5 L MACHINE_B |
| 7 | 6 COLUMNS |
| 8 | 7 WIDGET1 PROFIT 5.0 |
| 9 | 8 WIDGET1 MACHINE_A 2.0 |
| 10 | 9 WIDGET1 MACHINE_B 1.0 |
| 11 | 10 WIDGET2 PROFIT 3.0 |
| 12 | 11 WIDGET2 MACHINE_A 1.0 |
| 13 | 12 WIDGET2 MACHINE_B 4.0 |
| 14 | 13 RHS |
| 15 | 14 TIME_AVL MACHINE_A 100.0 |
| 16 | 15 TIME_AVL MACHINE_B 150.0 |
| 17 | 16 ENDATA |
| 18 | ; |
| 19 | RUN; |
Étapes de réalisation
1
Execution of the conversion action specifying the FIXED format.
Copied!
| 1 | |
| 2 | PROC CAS; |
| 3 | optimization.convertMps / |
| 4 | DATA={name='mps_fixed_source'} FORMAT='FIXED' casOut={name='mps_converted_fixed', replace=true}; |
| 5 | |
| 6 | RUN; |
| 7 | |
| 8 | QUIT; |
| 9 |
2
Verification of the output table structure (checking if 7 columns were generated).
Copied!
| 1 | |
| 2 | PROC CAS; |
| 3 | TABLE.tableInfo / TABLE='mps_converted_fixed'; |
| 4 | |
| 5 | RUN; |
| 6 | |
| 7 | QUIT; |
| 8 |
Expected Result
The action should successfully parse the fixed-width strings. The resulting 'mps_converted_fixed' table must contain the standard 7-column MPS schema, ready for the solveLp action.