Exporting Data Set and Variable Names (mspsas6)
/***************************************************************/
/* */
/* S A S S A M P L E L I B R A R Y */
/* */
/* NAME: mspsas6 */
/* TITLE: Exporting Data Set and Variable Names (mspsas6) */
/* 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);