Resources

Round Trip between SAS and Microsoft Project (mspsas9)

/*******************************************************************/
/*                                                                 */
/*             S A S   S A M P L E   L I B R A R Y                 */
/*                                                                 */
/*    NAME: mspsas9                                                */
/*   TITLE: Round Trip between SAS and Microsoft Project (mspsas9) */
/* PRODUCT: OR                                                     */
/*  SYSTEM: ALL                                                    */
/*    KEYS: OR                                                     */
/*   PROCS: PM, SAS/ACCESS                                         */
/*    DATA:                                                        */
/*                                                                 */
/* SUPPORT:                             UPDATE:                    */
/*     REF:                                                        */
/*    MISC: Example 9 from the The Microsoft Project               */
/*          Conversion Macros chapter of Project Management        */
/*                                                                 */
/*******************************************************************/



/*******************************************************************

 This example demonstrates how to convert a Microsoft Project (MSP)
 database file into SAS using the %MSPTOSAS macro, then convert the
 file back to MSP using the %SASTOMSP macro.

 *******************************************************************/


%msptosas(mdbfile=!SASROOT\or\sasmisc\mspsas1.mdb,
library=C:\MSPROJ, version=98)


/*******************************************************************

 After the successful run, seven data sets and one callpm.sas file
 have been generated. The following SAS code can be found either in
 the callpm.sas file or in the SAS log.

libname mspout "C:\MSPROJ";
PROC PM data = mspout.activity project=mspout.prefs
     caledata = mspout.calendar
     workdata = mspout.workday
     out=mspout.schedule
     interval=dtday
     date="17DEC06:08:00:00"dt
     daylength=" 8:00"t
     suppressobswarn
     setfinishmilestone;
activity ACTID;
successor SUCCUID / LAG = LAG;
duration DURATION;
project PNTUID;
id ACTIVITY ACTUID;
RUN;

 By taking the parameters from the preceding PM invocation, you can
 specify the values in the following %SASTOMSP call. The %SASTOMSP
 macro converts the project back into Microsoft Project format.

 *******************************************************************/


/*******************************************************************
 In this example we use a file reference mspref to specify
 the path and file name of the mdb file to be created by the
 macro %SASTOMSP.

 filename mspref "C:\MSPROJ\sasmsp5.mdb";

 You may want to change it to a file name you want.
 If you don't define mspref as a sas file reference, a file
 mspref.mdb will be created in the default path of the OUTFILE=
 option of PROC EXPORT. In many cases, this default path is
 'C:\Documents and Settings\username\'. See the documentation
 for details.

 *******************************************************************/

filename mspref "C:\MSPROJ\sasmsp5.mdb";
%sastomsp(library=C:\MSPROJ, mdbfile=mspref,
          actds=activity, calds=calendar, workds=workday,
          scheduleds=schedule, _interval=dtday,
          _date="17DEC06:08:00:00"dt, _daylength=" 8:00"t,
          _activity=ACTUID, _successor=SUCCUID,
          _lag=LAG, _dur=DURATION, _project=PNTUID,
          _id=ACTIVITY ACTUID)