%MSPTOSAS

%MSPTOSAS is a SAS macro that converts Microsoft Project data saved in an MDB (Microsoft Access database) or XML format into data sets that are readable by the PM procedure. %MSPTOSAS requires specification of the location and name of either the MDB or the XML file (but not both), and it requires specification of the version of Microsoft Project that was used to create input. You can also include optional arguments to specify a location for storing SAS data sets, to control the mode of the PM procedure invocation, or to 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.