Cacher is the code snippet organizer for pro developers

proc sql;
  connect to oracle (user=&_whouseUser password=&_whousePass path=&_whousePath);
  create table TABLENAME as
  select *
  from connection to oracle
    (select *
     from &_whouseSchema..table
     SQL SELECT CODE);
  disconnect from oracle;
quit;