ACCESS Procedure Reference

Invoking the ACCESS Procedure

To invoke the ACCESS procedure you use the options described in PROC ACCESS Statement Options and certain procedure statements. The options and statements you choose are defined by your task.

To create an access descriptor:

PROC ACCESS DBMS=IMS;

CREATE libref.member-name.ACCESS;

required database-description statements;

optional editing statements;

RUN;

To create an access descriptor and a view descriptor in the same procedure:

PROC ACCESS DBMS=IMS;

CREATE libref.member-name.ACCESS;

required database-description statements;

optional editing statements;

CREATE libref.member-name.VIEW;

SELECT item-list;

optional editing statements;

RUN;

To create a view descriptor from an existing access descriptor:

PROC ACCESS DBMS=IMS ACCDESC=libref.access-descriptor;

CREATE libref.member-name.VIEW;

SELECT item-list;

optional editing statements;

RUN;
To update an access descriptor:

PROC ACCESS DBMS=IMS;

UPDATE libref.member-name.ACCESS;

procedure statements;

RUN;
To update a view descriptor:

PROC ACCESS DBMS=IMS;

UPDATE libref.member-name.VIEW;

procedure statements;

RUN;

Note that when you update an access descriptor (for example, drop another field from the display), the view descriptors based on this access descriptor are not updated automatically. You must re-create or modify any view descriptors that you want to reflect the changes made to the access descriptor. Altering a DBMS table can invalidate both access descriptors and view descriptors.

Top of Page