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).

See Statement Sequence for Accomplishing Tasks with the ACCESS Procedure for the appropriate sequence of statements for creating access and view descriptors.

Example

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

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;