The Microsoft Project Conversion Macros

(View the complete code for this example.)

This example illustrates how to convert a Microsoft Project file that was saved in XML format to SAS data sets. Microsoft Project 2007 is initially used to save the project from Example 5.2 in XML format.

You can use the following SAS macro call to convert this project:

   %msptosas(xmlfile=C:\MSPROJ\mspsas2.xml, version=2007)

Since the MAPFILE= option is not specified, the map file mspxml.map is created and used. After the conversion, the PM window that shows the converted project is displayed, as shown in Figure 10. The display is the same as that shown in Figure 2.You can customize the display by following the same steps as in Example 5.2. Figure 11 shows the merged data set.

Figure 10: PM Window

Figure 11: Merged Data Set