SAS: SQL pass through - Oracle

Create a table

%let ora_user     = rene;
%let ora_password = secret_garden;
%let ora_server   = ora.test.renenyffenegger.ch;

proc sql;

  connect to oracle as tq84_ora (
    user     = &ora_user
    password = &ora_password
    path     = &ora_server
  );

  execute (
    create table tq84_pass_through (
      id    number primary key,
      col_1 varchar2(10) not null,
      dt    date
    )
  )
  by tq84_ora;

  %put &sqlxrc &sqlxmsg;

quit;

See also