ACCESS Procedure

CREATE Statement

Creates a SAS/ACCESS descriptor file

Requirement: This statement is required.
Interaction: applies to access descriptor or view descriptor
See: Statement Sequence for Accomplishing Tasks

Syntax

Required Arguments

libref.member-name

identifies the libref of the SAS library where you want to store the descriptor and identifies the descriptor name.

ACCESS

specifies an access descriptor.

VIEW

specifies a view descriptor.

Optional Argument

password-option

specifies a password.

Details

This statement names the access descriptor or view descriptor that you are creating. Use a three-level name:

  • The first level identifies the libref of the SAS library where you want to store the descriptor.
  • The second level is the descriptor name.
  • The third level specifies the type of SAS file (specify ACCESS for an access descriptor or VIEW for a view descriptor).

Example

Within the same PROC ACCESS step, this example creates an AdLib.Employ access descriptor on the Employees Oracle table and a Vlib.Emp1204 view descriptor based on AdLib.Employ.

proc access dbms=oracle;

   /* create access descriptor  */
   create adlib.employ.access;
   database='qa:[dubois]textile';
   table=employees;
   assign=no;
   list all;

   /* create view descriptor  */
   create vlib.emp1204.view;
   select empid lastname hiredate salary dept
   gender birthdate;
   format empid 6.
          salary dollar12.2
          jobcode 5.
          hiredate datetime9.
          birthdate datetime9.;
   subset where jobcode=1204;
run;
Last updated: February 3, 2026