Kindly let me know how we know library name of a table by using base programing code.
Regards,
Ashwini
An easy way is useing dictionary table.
proc sql; select libname,memname from dictionary.members where memname='CLASS'; quit;
Ksharp
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
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.
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
While KSharp may have already answered your question, I'm not sure! Is that what you meant or were you asking something else?
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.