The ACCESS Procedure for Relational Databases Creating a View Descriptor 311
run;
By specifying the ALTER level of password, you can read the AdLib.Customer access
descriptor and create the Vlib.Customer view descriptor.
Examples of Using the ACCESS Procedure
Updating an Access Descriptor
The following example updates an access descriptor AdLib.Employ on the Oracle Rdb
table Employees. The original access descriptor includes all of the columns in the table.
The updated access descriptor omits the Salary and BirthDate columns.
proc access dbms=rdb ad=adlaib.employ;
/* update access descriptor */
update adlib.employ.access;
drop salary birthdate;
list all;
run;
Using the LIST statement enables you to write all of the variables to the SAS log so
that you can see the complete access descriptor before you update it.
Creating a View Descriptor
In this example, you re-create a view descriptor VLIB.EMP1204, which is based on
an access descriptor (ADLIB.EMPLOY) that was previously updated.
proc access dbms=rdb;
/* 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;
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.
