topic how we know library of a table in SAS Programming

how we know library of a table

Ashwini — Fri, 20 Jan 2012 10:45:25 GMT

Kindly let me know how we know library name of a table by using base programing code.

Regards,

Ashwini

how we know library of a table

Ksharp — Fri, 20 Jan 2012 11:57:58 GMT

An easy way is useing dictionary table.

proc sql;
 select libname,memname
  from dictionary.members
   where memname='CLASS';
quit;

Ksharp

how we know library of a table

art297 — Fri, 20 Jan 2012 12:03:33 GMT

While KSharp may have already answered your question, I'm not sure! Is that what you meant or were you asking something else?

how we know library of a table

Ashwini — Fri, 20 Jan 2012 12:10:02 GMT

Dear Ksharp,

If it table is an sql table then we use Dictionay.But i have table ,i don't know the library or location of table .I know only the name of table.How we can search a table by using base code.

Regard,

Ashwini

how we know library of a table

art297 — Fri, 20 Jan 2012 12:13:50 GMT

What Ksharp referred to was a table of tables, not a sql specific table.

If you are talking about a table that is already in a libname that has already been assigned during a session, then his proposed code should accomplish what you want.

how we know library of a table

Ksharp — Fri, 20 Jan 2012 12:15:55 GMT

As long as you know the name of table , the code you give you all the library name which contains the table name you want to search.

E.X.

If you want to find all the library which contain a table named 'CLASS' ,then the code below will list all the libraries.

proc sql;

select libname,memname

from dictionary.members

where memname='CLASS';

quit;

Ksharp