The Microsoft Project Conversion Macros

%MSPTOSAS

%MSPTOSAS is a SAS macro that converts Microsoft Project data saved in MDB format to a form that is readable by the PM procedure. %MSPTOSAS has two required arguments: one specifies the location and name of the MDB file, and the other specifies which version of Microsoft Project the MDB file corresponds to. In addition to the two required arguments, there are optional arguments that enable you to specify a location for storing SAS data sets, control the mode of the PM procedure invocation, and run the %MSPTOSAS macro on UNIX.

The %MSPTOSAS macro converts the hierarchical relationships, precedence relationships, time constraints, resource availabilities, resource requirements, project calendars, task calendars, resource calendars, holiday information, work-shift information, actual start and finish times, and baseline start and finish times. In addition, the task custom fields are extracted and stored in the Task_Attributes data set.


%MSPTOSAS Macro Parameters

%MSPTOSAS Macro Output

Previous Page | Next Page | Top of Page