MDBTOPM Macro

The PM Procedure

MDBTOPM Macro

MDBTOPM is a SAS macro that converts Microsoft Project data saved in MDB format to a form that is readable by the PM procedure. In the event of a succesful conversion, the macro 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 the MDBTOPM macro requires SAS/ACCESS software.

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. The following SAS data sets are generated by the MDBTOPM macro:

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

The MDBTOPM macro converts 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