Multiple LIBNAME statements can be specified, separated by commas. In the following example, a connection is made and the libref ACCREC is assigned to an ORACLE database. create view proclib.view1 as ...

proc sql; connect to oracle (user=scott password=tiger); execute (create view whotookorders as select ordernum, takenby, firstname, lastname, phone from orders, ... The ORACLE SQL query is enclosed in ...