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.
For Oracle tables, check out this paper:
For Other database, you can find their Meta data info here:
Information schema - Wikipedia, the free encyclopedia
Haikuo
Also try exploring proc datasets, I guess that shiould help you!
Thanks, KeShan. This is indeed very handy.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.