Simple %SASTOMSP Conversion (mspsae05)

/***************************************************************/
/*                                                             */
/*             S A S   S A M P L E   L I B R A R Y             */
/*                                                             */
/*    NAME: mspsae05                                           */
/*   TITLE: Simple %SASTOMSP Conversion (mspsae05)             */
/* PRODUCT: OR                                                 */
/*  SYSTEM: ALL                                                */
/*    KEYS: OR                                                 */
/*   PROCS: PM, SAS/ACCESS                                     */
/*    DATA:                                                    */
/*                                                             */
/* SUPPORT:                             UPDATE:                */
/*     REF:                                                    */
/*    MISC: Example 5 from the The Microsoft Project           */
/*          Conversion Macros chapter of Project Management    */
/*                                                             */
/***************************************************************/



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

 This example created an activity data set and displayed
 the project in PROC PM.

 Then the conversion macro %SASTOMSP was used to convert
 the SAS data set to an MDB file that is readable by
 Microsoft Project.

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



/***************************************************************
 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\sasmsp1a.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.

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


data activity;
   format activity succ1 $8.;
   input activity dur succ1;
   datalines;
Design    5  Develop
Develop  10  Document
Develop  10  Test
Document  6  Ship
Test      8  Ship
Ship      0  .
;

proc pm data=activity;
    act activity;
    succ succ1;
    duration dur;
run;

%sastomsp(mdbfile=mspref);

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

 To create a project schedule that is consistent across both
 PROC PM and Microsoft Project, you need to add an additional
 option in both the PROC PM and the %SASTOMSP macro statement.

 In the call to PROC PM, you need to add the DATE = option to
 start the project on a given date. For the call to %SASTOMSP,
 you specify this same starting date using the _DATE = parameter.

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


/***************************************************************
 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\sasmsp1b.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.

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

proc pm data=activity date='15Dec06'd;
   act activity;
   succ succ1;
   duration dur;
run;