ACCESS Procedure

Example 2: Create a View Descriptor

Features:
Statements:
PROC ACCESS
CREATE
SELECT
FORMAT
SUBSET
Because SELECT and RESET are not supported when UPDATE is used, the view descriptor Vlib.Emp1204 must be re-created to omit the Salary and BirthDate columns.
The following example re-creates a view descriptor, VLIB.EMP1204, which is based on an access descriptor, ADLIB.EMPLOY, which was previously updated.
proc access dbms=oracle;

   /* re-create view descriptor  */

   create vlib.emp1204.view;
   select empid hiredate dept jobcode gender
      lastname firstname middlename phone;
   format empid 6.
          jobcode 5.
          hiredate datetime9.;
   subset where jobcode=1204;
run;