The Microsoft Project Conversion Macros


%SASTOMSP

%SASTOMSP is a SAS macro that converts data sets used by the PM and CPM procedures into a file that is readable by Microsoft Project 2000, 2002, and 2003.

Note: The MDB file created by the %SASTOMSP macro cannot be read directly by versions of Microsoft Project dated 2007 or later. This issue can be circumvented by opening the MDB file in Microsoft Project 2003, then saving the file in a format supported by versions of Microsoft Project dated 2007 or later (.mpp or .xml, for example).

The macro converts information that is common to both the CPM and PM procedures and Microsoft Project, including hierarchical relationships, precedence relationships, time constraints, resource availabilities, resource requirements, project calendars, resource calendars, task calendars, holiday information, and work-shift information. In addition, the early and late schedules, the actual schedule, the resource-constrained schedule, and the baseline schedule are also extracted and stored as start-finish fields.