If you are interested, the following SAS codes can help you import tables from Oracle into SAS.
/*get two tables from Oracle*/
rsubmit;
%macro recent(dsnin1=,dsnout1=,vars=);
proc sql stimer noerrorstop;
%include ‘~/connect.dssp’;
%put &sqlxmsg;
create table &dsnout1 as
select * from connection to ora (
select &vars
from
&dsnin1);
disconnect from ora;
quit;
%mend recent;
options nomlogic nomprint;
%recent(dsnin1=orcale_schma_name1.table_name,dsnout1=new_table_name1,vars=*);
%recent(dsnin1=orcale_schma_name2.table_name,dsnout1=new_table_name2,vars=*);
endrsubmit;