Search notes:

SAS: SQL pass through - connect using

With an existing library, a pass through SQL statement can be executed as follows:
%let ora_user     = rene;
%let ora_password = secret_garden;
%let ora_server   = ora.test.renenyffenegger.ch;


libname tq84_ora
   oracle 
   user                     = &ora_user
   password                 = &ora_password
   path                     = &ora_server
   sql_functions            = all
   db_length_semantics_byte = no;


proc sql;
   connect using tq84_ora;

   select * from connection to tq84_ora (
      select   *
      from     all_objects
      where    owner not in ('SYS', 'SYSTEM', 'XDB', 'OUTLN', 'APEX_050000', 'PUBLIC')
      order by owner, object_type, object_name
   );

   disconnect from tq84_ora;
quit;

libname tq84_ora clear;
Github repository about-SAS, path: /programming/proc/sql/connect-using/oracle.sas

See also

proc sql - connect to

Index