Optional Arguments

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.

Valid in: PROC SQL

Restriction:The ACCESS Procedure is supported only in V6 SAS.

ACCDESC= libref.access-descriptor READ | 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. 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.

READ

specifies permission to read an existing access descriptor.

WRITE

specifies permission to write to an existing access descriptor.

ALTER

specifies permission to alter an existing access descriptor.

Alias: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= option.

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

See:The EXPORT Procedure

The IMPORT Procedure