Business Context
A financial analyst is testing a prototype portfolio model with very few constraints but irregular formatting (extra spaces) in a 'FREE' format file. This 'Edge Case' tests if the parser is robust enough to handle irregular whitespace and minimal problem definitions often found in early-stage modeling.
Data Preparation
Creation of a small, irregularly spaced 'FREE' format MPS table.
Copied!
| 1 | DATA casuser.mps_irregular; INFILE DATALINES; INPUT id line $80.; DATALINES; |
| 2 | 1 NAME PORTFOLIO |
| 3 | 2 ROWS |
| 4 | 3 N RETURN |
| 5 | 4 L RISK |
| 6 | 5 COLUMNS |
| 7 | 6 ASSET_A RETURN 0.05 |
| 8 | 7 ASSET_A RISK 0.02 |
| 9 | 8 ASSET_B RETURN 0.08 |
| 10 | 9 ASSET_B RISK 0.12 |
| 11 | 10 RHS |
| 12 | 11 LIMIT RISK 0.05 |
| 13 | 12 ENDATA |
| 14 | ; |
| 15 | RUN; |
Étapes de réalisation
1
Execution on the irregular data without specifying maxLength (testing default behavior).
Copied!
| 1 | |
| 2 | PROC CAS; |
| 3 | optimization.convertMps / |
| 4 | DATA={name='mps_irregular'} FORMAT='FREE' casOut={name='mps_clean_portfolio', replace=true}; |
| 5 | |
| 6 | RUN; |
| 7 | |
| 8 | QUIT; |
| 9 |
2
Check if the action failed or succeeded despite irregular spacing.
Copied!
| 1 | |
| 2 | PROC CAS; |
| 3 | SIMPLE.summary / TABLE='mps_clean_portfolio'; |
| 4 | |
| 5 | RUN; |
| 6 | |
| 7 | QUIT; |
| 8 |
Expected Result
The action should succeed because 'FREE' format is designed to handle variable whitespace. The output table 'mps_clean_portfolio' should be correctly structured, normalizing the input irregularities.