The Microsoft Project Conversion Macros

%MSPTOSAS Macro Parameters

%MSPTOSAS (MDBFILE=mdbfile, LIBRARY=library,
 VIEWPM=indicator, VERSION=version,
 DBMS=identifier, SERVER=pc-server-hostname,
 PORT=port-number);

General Project Parameters

LIBRARY=library
specifies the location of the directory for storing the SAS data sets and the file callpm.sas. This parameter can be either a SAS library reference or a path. A path can be specified with double quotes, single quotes, or no quotes. See the MDBFILE= parameter for an example. After a successful run of the %MSPTOSAS macro, the library reference 'mspout' is assigned to this path. The default value of the LIBRARY= parameter is 'WORK', which is the default libref generally assigned to your temporary SAS data library for the current session or job.

MDBFILE=mdbfile
specifies the location of the MDB file. It can be either a SAS file reference or a filename. A filename can be specified with double quotes, single quotes, or no quotes. For example, in the following %MSPTOSAS invocation, a filename is specified with double quotes:
  
    %msptosas(mdbfile="c:\mspproj\filename.mdb", library="c:\sasproj", 
              version=2003)
 
This parameter is required; there is no default value.

VERSION=version
specifies the Microsoft Project version of the MDB file format. For example, to convert an MDB file from Microsoft Project 2003 format, you need to specify VERSION=2003. Other recognizable versions are 98, 2000, and 2002. This parameter is required; there is no default value.

VIEWPM=indicator
controls the mode of the PM procedure invocation. The value VIEWPM=1 invokes the PM procedure in interactive mode, and the value VIEWPM=0 invokes the PM procedure in NODISPLAY mode. This parameter is optional; the default value is 1.

UNIX Parameters

The following statements are available to establish a connection from SAS running on UNIX to a SAS PC Files Server. This enables you to run the %MSPTOSAS macro on UNIX. For more information, see SAS/ACCESS Interface to PC Files: Reference.

DBMS=identifier
specifies the type of data to import. In this case, the value DBMS=accesscs must be specified.

PORT=port-number
specifies the port or service name that the SAS PC Files Server is listening to on the PC. The default value is 8621.

SERVER=pc-server-hostname
specifies the name of the computer on which you started the PC files server. This name is required by UNIX users to connect to this server machine and is reflected on the server control panel. This hostname can be specified as a simple computer name (e.g., wxp320), a fully qualified network name (e.g., wxp320.domain.com), or an IP address.

Previous Page | Next Page | Top of Page