The Microsoft Project Conversion Macros

%MSPTOSAS Macro Parameters

Subsections:

General Project Parameters
UNIX Parameters

%MSPTOSAS (	LIBRARY=library, MAPFILE=mapfile,
	MDBFILE=mdbfile, VERSION=version,
	VIEWPM=indicator, XMLFILE=xmlfile,
	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 that is generally assigned to your temporary SAS data library for the current session or job.
MDBFILE=mdbfile: specifies the location and filename of the MDB file. This parameter can be either a SAS file reference or a filename. A filename can be specified with double quotes, single quotes, or no quotes. One of MDBFILE= or XMLFILE= is required, but they cannot both be specified.
XMLFILE=xmlfile: specifies the location and filename of the XML file. This parameter can be either a SAS file reference or a filename. A filename can be specified with double quotes, single quotes, or no quotes. One of MDBFILE= or XMLFILE= is required, but they cannot both be specified.
MAPFILE=mapfile: specifies the location and filename of the XML map file. The map file is a separate XML document that contains specific XML map syntax. The map file tells the XML engine how to interpret the XML markup in order to successfully import the XML document. This parameter can only be used when XMLFILE= is specified. The value of MAPFILE= can be either a SAS file reference or a filename. A filename can be specified with double quotes, single quotes, or no quotes. If XMLFILE= is specified and MAPFILE= is not, a map file named mspxml.map will be created in the WORK directory and used as the XML map file. For more information related to the XML engine and XML map syntax, refer to SAS XML LIBNAME Engine User’s Guide.
VERSION=version: specifies the version of Microsoft Project used to create the MDB or XML file. The supported versions for MDB files are 98, 2000, 2002 and 2003. The supported versions for XML files are 2002, 2003, 2007, and 2010. This parameter is required; there is no default value. For example, to convert an MDB file from Microsoft Project 2003 format, you need to specify VERSION=2003.
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.