The ACCESS Procedure for Relational Databases |
The following
example updates an access descriptor AdLib.Employ
on the Oracle 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=oracle ad=adlaib.employ;
/* update access descriptor */
update adlib.employ.access;
drop salary birthdate;
list all;
run;
You can use the LIST statement to write all variables to the SAS
log so that you can see the complete access descriptor before you update it.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.