The MPS-Format SAS Data Set


Example 17.4 Using the %MPS2SASD Macro

We illustrate the use of the %MPS2SASD macro in this example, assuming the files example_fix.mps and example_free.mps are in your current SAS working directory.

The MPS2SASD macro function has one required parameter, MPSFILE= 'infilename', which specifies the path and name of the MPS/QPS-format file. With this single parameter, the macro reads the file, converts the records, and saves the conversion to the default MPS-format SAS data set MPSDATA.

Running the following statements converts the fixed-format MPS file shown in Example 17.2 to the MPS-format SAS data set MPSDATA:

%mps2sasd(mpsfile='example_fix.mps');
proc print data=mpsdata;
run;

Output 17.4.1 displays the MPS-format SAS data set MPSDATA.

Output 17.4.1: The MPS-Format SAS Data Set MPSDATA

Obs field1 field2 field3 field4 field5 field6
1 NAME   PROD_MIX .   .
2 ROWS     .   .
3 N PROFIT   .   .
4 L STAMP   .   .
5 L ASSEMB   .   .
6 L FINISH   .   .
7 COLUMNS     .   .
8   DESK STAMP 3.0 ASSEMB 10
9   DESK FINISH 10.0 PROFIT -95
10   CHAIR STAMP 1.5 ASSEMB 6
11   CHAIR FINISH 8.0 PROFIT -41
12   CABINET STAMP 2.0 ASSEMB 8
13   CABINET FINISH 8.0 PROFIT -84
14   BOOKCSE STAMP 2.0 ASSEMB 7
15   BOOKCSE FINISH 7.0 PROFIT -76
16 RHS     .   .
17   TIME STAMP 800.0 ASSEMB 1200
18   TIME FINISH 800.0   .
19 RANGES     .   .
20   T1 ASSEMB 900.0   .
21 BOUNDS     .   .
22 UP BND CHAIR 75.0   .
23 LO BND BOOKCSE 50.0   .
24 ENDATA     .   .



Running the following statement converts the free-format MPS file shown in Example 17.3 to the MPS-format SAS data set MPSDATA:

%mps2sasd(mpsfile='example_free.mps');

The data set is identical to the one shown in Output 17.4.1.

In the following statement, when the free-format MPS file is converted, the length of the variables field2, field3, and field5 in the SAS data set MPSDATA is explicitly set to 10 characters:

%mps2sasd(mpsfile='example_free.mps', maxlen=10, format=free);

If you want to save the converted data to a SAS data set other than the default data set MPSDATA, you can use the parameter OUTDATA= mpsdata. The following statement reads data from the file example_fix.mps and writes the converted data to the data set PRODMIX:

%mps2sasd(mpsfile='example_fix.mps', outdata=PRODMIX);