create view proclib.view1 as select * from accrec.invoices as invoices using libname accrec oracle user=username pass=password path='dbms-path'; For more information on the SAS/ACCESS LIBNAME ...