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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.