05-24-2011 12:42 PM
06-01-2011 01:21 PM
09-14-2017 04:13 PM
WHERE UPCASE(LIBNAME) like 'the library name u are searching for'
AND UPCASE(MEMNAME) like 'if u remember one of the table name' ;
for example; the libname is ECOWAS and one of the table name is Nigeria
WHERE UPCASE(LIBNAME) like 'ECOWAS'
AND UPCASE(MEMNAME) like 'NIG%' ;
09-14-2017 04:22 PM
I've read (but not verified/tested) that SQL Server supports the information_schema view that allows you to find all of the tables and attributes. If that's the case, you could use PROC SQL passthrough to CONNECT to the database and issue a query that brings that information back into SAS.
See this blog post for more info: Using PROC SQL to get the schema of a MySQL database. It's written for MySQL, but should be easy to adapt.