Help using Base SAS procedures

A question on SAS dictionary tables

Reply
N/A
Posts: 1

A question on SAS dictionary tables

I am new to use SAS dictionary tables. I have ODBC connection to an oracle database. I do not have a database diagram and try to use SAS dictionary to display the tables in this database. I can successfully display the members (the library I defined) of my dictionary. I wonder if I can display the data/tables within the library and how.

Here are the codes I wrote.

/*my connection to the database*/

libname sql odbc prompt; /*define sql as the libname*/

%put %superq(sysdbmsg);

/*display all the libraries i have ever defined*/

proc sql;

     select *

     from dictionary.tables;

quit;

Library sql is one of them. The member name is CTAR_Datamart_prod and name is ODBC. all other information are empty. How can I display the tables in this sql library. Thanks.

Respected Advisor
Posts: 3,124

Re: A question on SAS dictionary tables

For Oracle tables, check out this paper:

http://www.scsug.org/SCSUGProceedings/2011/poling2/FINDING%20ORACLE%20TABLE%20METADATA%20WITH%20SAS....

For Other database, you can find their Meta data info here:

Information schema - Wikipedia, the free encyclopedia

Haikuo

Occasional Contributor
Posts: 15

Re: A question on SAS dictionary tables

Also try exploring proc datasets, I guess that shiould help you!


Super User
Posts: 9,691

Re: A question on SAS dictionary tables

Respected Advisor
Posts: 3,124

Re: A question on SAS dictionary tables

Thanks, KeShan. This is indeed very handy.

Respected Advisor
Posts: 3,902

Re: A question on SAS dictionary tables

When using Oracle I find it very helpful to also use SQLDeveloper (free client, can be downloaded from Oracle).

...and as a hint: When downloading/installing the 64bit Windows SQLDeveloper version point it to a 32 bit jdk (version 6.x) - took me a lot of Googling to figure this one out.

Ask a Question
Discussion stats
  • 5 replies
  • 381 views
  • 2 likes
  • 5 in conversation