The EXPORT Procedure

Example 3: Exporting a Microsoft Access Table

Procedure features:

PROC EXPORT statement arguments:

	DATA=
	DBMS=
	OUTTABLE=
	REPLACE

Data Source Statement:

DATABASE=

This example exports a SAS data set named SASUSER.CUST, the first five observations of which follow, and creates a Microsoft Access table. The security level for this Access table is none, so it is not necessary to specify any of the database security statements (DBPWD=, PWD=, UID=, or WGDB=).

Obs     Name                    Street                    Zipcode

 1      David Taylor            124 Oxbow Street          72511
 2      Theo Barnes             2412 McAllen Avenue       72513
 3      Lydia Stirog            12550 Overton Place       72516
 4      Anton Niroles           486 Gypsum Street         72511
 5      Cheryl Gaspar           36 E. Broadway            72515

Program

proc export data=sasuser.cust

outtable="customers"

dbms=access

replace;

database="c:\myfiles\mydatabase.mdb"; run;

Chapter Contents
Previous
Next
Top of Page