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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.