The ACCESS Procedure for Relational Databases

CREATE Statement

Creates a SAS/ACCESS descriptor file

Applies to:

access descriptor or view descriptor

CREATE libref.member-name.ACCESS | VIEW <password-option>;

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.
password-option: specifies a password.

Details

The CREATE statement is required. It 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).

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

Example

The following 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;

Top of Page