The EXPORT Procedure

Data Source Statements

Featured in:

Exporting a Delimited External File and Exporting a Microsoft Access Table

PROC EXPORT provides a variety of statements that are specific to the output data source.

Statement for Delimited Files
The following statement is available to export delimited external files.

DELIMITER='char' | 'nn'x

specifies the delimiter to separate columns of data in the output file. You can specify the delimiter as a single character or as a hexidecimal value. For example, if you want columns of data to be separated by an ampersand, specify DELIMITER='&'. If you do not specify DELIMITER=, PROC EXPORT assumes that the delimiter is a blank. You can replace the equals sign with a blank.

Interaction:	You do not have to specify DELIMITER= if you specify DBMS=CSV or DBMS=TAB or if the output filename has an extension of .CSV or .TXT.
Featured in:	Exporting a Delimited External File

Statements for DBMS Tables
The following statements are available to establish a connection to the DBMS when you export a DBMS table.

DATABASE="database"

specifies the complete path and filename of the database to contain the specified DBMS table. If the database name does not contain lowercase characters, special characters, or national characters, you can omit the quotes. You may replace the equals sign with a blank.

Note: A default may be configured in the DBMS client software; the SAS System does not generate a default value. [cautionend]

Featured in: Exporting a Microsoft Access Table

DBPWD="database password"

specifies a password that allows access to a database. You may replace the equals sign with a blank.

Interaction:

DBPWD= cannot be used with PWD=.

PWD="password"

specifies the user password used by the DBMS to validate a specific userid. If the password does not contain lowercase characters, special characters, or national characters, you can omit the quotes. You may replace the equals sign with a blank.

Note: The DBMS client software may default to the userid and password that was used to log in to the operating environment; the SAS System does not generate a default value. [cautionend]

Interaction: PWD= cannot be used with DBPWD=.

UID="password"

identifies the user to the DBMS. If the userid does not contain lowercase characters, special characters, or national characters, you can omit the quotes. You can replace the equals sign with a blank.

Note: The DBMS client software may default to the userid and password that was used to log in to the operating environment; the SAS System does not generate a default value. [cautionend]

WGDB="workgroup-database-name"

specifies the workgroup (security) database name that contains the USERID and PWD data for the DBMS. If the workgroup database name does not contain lowercase characters, special characters, or national characters, you can omit the quotes. You may replace the equals sign with a blank.

Note: A default workgroup database may be used by the DBMS; the SAS System does not generate a default value. [cautionend]

Security Levels for Microsoft Access Tables

Microsoft Access tables have three levels of security, for which specific combinations of security statements must be used.

None: Do not specify DBPWD=, PWD=, UID=, or WGDB=.
Password: Specify only DBPWD=.
User-level: Specify only PWD=, UID=, and WGDB=.

Each statement has a default value; however, you may find it necessary to provide a value for each statement explicitly.

Chapter Contents
Previous
Next
Top of Page