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.
... View more