Exporting Data Set and Variable Names (mspsae06)

/***************************************************************/
/*                                                             */
/*             S A S   S A M P L E   L I B R A R Y             */
/*                                                             */
/*    NAME: mspsae06                                           */
/*   TITLE: Exporting Data Set and Variable Names (mspsae06)   */
/* PRODUCT: OR                                                 */
/*  SYSTEM: ALL                                                */
/*    KEYS: OR                                                 */
/*   PROCS: PM, SAS/ACCESS                                     */
/*    DATA:                                                    */
/*                                                             */
/* SUPPORT:                             UPDATE:                */
/*     REF:                                                    */
/*    MISC: Example 6 from the The Microsoft Project           */
/*          Conversion Macros chapter of Project Management    */
/*                                                             */
/***************************************************************/



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

 This example shows how to use non-default values for the data
 set names and variable names in the conversion macro %SASTOMSP.

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



/***************************************************************
 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\sasmsp2.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 software;
   format task s1 s2 $8.;
   input task duration s1 s2;
   datalines;
Design    5  Develop   .
Develop  10  Document  Test
Document  6  Ship      .
Test      8  Ship      .
Ship      0  .         .
;

proc pm data=software date='15Dec06'd;
   act task;
   succ s1 s2;
   duration duration;
run;

filename mspref "C:\MSPROJ\sasmsp2.mdb";
%sastomsp(mdbfile=mspref,
          actds=software,
          _activity=task,
          _dur=duration,
          _successor=s1 s2,
          _date='15Dec06'd);