![](https://pdfstore-manualsonline.prod.a.ki/pdfasset/b/da/bda6fccb-b246-43e7-a520-a01ed647b8cf/bda6fccb-b246-43e7-a520-a01ed647b8cf-bg136.png)
300 CREATE Statement Appendix 1
identifies the libref of the SAS data library where you will store the descriptor and
the descriptor’s name.
ACCESS
specifies an access descriptor.
VIEW
specifies a view descriptor.
password-option
specifies a password.
Details
The CREATE statement is required. The CREATE statement names the access
descriptor or view descriptor that you are creating. Use a three-level name where the
first level identifies the libref of the SAS data library where you will store the
descriptor, the second level is the descriptor’s name, and the third level specifies the
type of SAS file (specify
ACCESS
for an access descriptor or
VIEW for a view descriptor).
See Table A1.1 on page 296 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 Rdb
table Employees, and a view descriptor Vlib.Emp1204 based on AdLib.Employ, in the
same PROC ACCESS step.
proc access dbms=rdb;
/* 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;