Microsoft Project Data Conversion

The PM Procedure

Microsoft Project Data Conversion

There are two SAS macros, MDBTOPM and MP2KTOPM, that are available for converting Microsoft ® Project data to a form that is readable by the PM procedure. MDBTOPM converts Microsoft Project 98 data and MP2KTOPM converts Microsoft Project 2000 data. In the event of a succesful conversion, each of these macros proceeds to invoke an instance of the PM procedure using values for the relevant options that were determined during the course of the data conversion. Execution of these macros requires SAS/ACCESS software.

MDBTOPM is a SAS macro that converts Microsoft Project 98 data saved in MDB format to a form that is readable by the PM procedure. The MDBTOPM macro has two arguments: one that specifies the location of the .MDB file and another that specifies the location of the directory for storing the SAS data sets.

MP2KTOPM is a SAS macro that converts Microsoft Project 2000 data saved in MDB format to a form that is readable by the PM procedure. The MP2KTOPM macro has three arguments: one that specifies the location of the .MDB file, one that specifies the location of the directory for storing the SAS data sets, and an optional numeric third argument that controls the mode of the PM procedure invocation. A nonzero value invokes the PM procedure in the default interactive mode and a value of zero invokes the PM procedure in noninteractive mode.

The following SAS data sets are generated by the conversion macros:

Activity data set
Calendar data set
Holiday data set
Workday data set
Resource data set
Preferences data set

The MDBTOPM and MP2KTOPM macros convert the hierarchical relationships, precedence relationships, time constraints, resource availabilities, resource requirements, project calendars, resource calendars, holiday information, workshift information, actual start and finish times, and baseline start and finish times. In addition, the notes and cost fields are also extracted and stored in the Activity data set.

Note: In order to retain the values of the options used to invoke the PM procedure, you will need to save the preferences by choosing Preferences->Save from the "Project" pull-down menu.

Chapter Contents
Previous
Next
Top