The SAS Output Delivery System and reporting techniques

Getting all tables from Oracle

Reply
New Contributor
Posts: 3

Getting all tables from Oracle

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

Thanks
SAS Super FREQ
Posts: 8,743

Re: Getting all tables from Oracle

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
New Contributor
Posts: 4

Re: Getting all tables from Oracle

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;
Ask a Question
Discussion stats
  • 2 replies
  • 143 views
  • 0 likes
  • 3 in conversation