The ACCESS Procedure for PC Files

PROC ACCESS Statement

Requirement:	This statement is required.
Valid:	for DBF, DIF, WK1, WK3, WK4, Excel 4, Excel 5, and Excel 95 files under Windows operating environments

PROC ACCESS<option(s)>;

Options

The PROC ACCESS statement options that are available with all supported PC file formats are described below. Other options, specific to particular PC file formats, are described in the file format specific chapter.

DBMS=pc-file-format

specifies the PC file format that you want to access. Specify DBMS=DBF for DBF files, DBMS=DIF for DIF files, DBMS=WK1|WK3 | WK4 for WKn files, or DBMS=XLS for XLS files. The DBMS option is required.

ACCDESC=libref.access-descriptorREAD|WRITE|ALTER=password

specifies an existing access descriptor.

Use this option when creating or updating a view descriptor based on an access descriptor that was created in a separate PROC ACCESS step.

You name the view descriptor in the CREATE statement. You can also use a SAS data set option on the ACCDESC= option to specify a SAS password for the access descriptor.

The ACCDESC= option has two aliases: AD= and ACCESS=.

VIEWDESC=libref.view-descriptor

specifies a view descriptor as input for the OUT= option.

See:

OUT=

OUT= <libref.>member-name

specifies a SAS data file. When VIEWDESC= and OUT= are used together, you can write data that is accessed from the view descriptor to the SAS data set that is specified in OUT=. Here is an example:

PROC ACCESS VIEWDESC=vlib.invq4
            OUT=dlib.invq4;
RUN;

Top of Page