Simple %SASTOMSP Conversion (mspsas5)
/***************************************************************/
/* */
/* S A S S A M P L E L I B R A R Y */
/* */
/* NAME: mspsas5 */
/* TITLE: Simple %SASTOMSP Conversion (mspsas5) */
/* 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;