you can connect SAS to Oracle database using two methods 1>>>LIBNAME statement using the ORACLE engine (provides direct and dynamic access to the Oracle data). libname oralib oracle user=scott password=xxxxx path=V2o7223 preserve_tab-names=yes; 2>>>The SQL Procedure Pass-Through Facility enables you to pass Oracle SQL statements to an Oracle database for processing. proc sql; connect to oracle(user=scott password=tiger path=dark_o8150); create table test1 as select * from connection to Oracle (select * from Dept where rownum <=5); quit;
... View more