PROC SQL; SELECT * FROM DICTIONARY.TABLES WHERE UPCASE(LIBNAME) like 'the library name u are searching for' AND UPCASE(MEMNAME) like 'if u remember one of the table name' ; QUIT; for example; the libname is ECOWAS and one of the table name is Nigeria PROC SQL; SELECT * FROM DICTIONARY.TABLES WHERE UPCASE(LIBNAME) like 'ECOWAS' AND UPCASE(MEMNAME) like 'NIG%' ; QUIT;
... View more