topic Re: Getting all tables from Oracle in ODS and Base Reporting

Getting all tables from Oracle

STOJA — Wed, 06 Feb 2008 16:19:39 GMT

What is the best way to see all my tables in Oracle data base as a sas data sets?

Thanks

Re: Getting all tables from Oracle

Cynthia_sas — Wed, 06 Feb 2008 18:32:12 GMT

Hi:
This is not a BASE SAS or Reporting Procedure (PRINT, REPORT, TABULATE) question.

Your best bet for help with this question is to contact SAS Tech Support. To contact Tech Support go to: http://support.sas.com and on the left-hand navigation area, look for the link entitled "Submit a Problem".

cynthia

Re: Getting all tables from Oracle

david2010 — Fri, 08 Feb 2008 03:01:26 GMT

The best way is to use the ORACLE libname statement.

libname oracle_db ORACLE USER='ASB" PASSWORD='123";
RUN;

All the tables should now be accessible.

This will give you the name of all the tables.

proc datasets library=oracle_db;quit;