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;
Copyright © SAS Institute Inc. All rights reserved.