Describe
proc sql;
describe table dictionary.members;
quit;
/*
create table DICTIONARY.MEMBERS
(
libname char(8) label='Library Name',
memname char(32) label='Member Name',
memtype char(8) label='Member Type',
dbms_memtype char(32) label='DBMS Member Type',
engine char(8) label='Engine Name',
index char(3) label='Indexes',
path char(1024) label='Pathname'
);
*/
Select members of a library
The following SQL statement selects the members of a
library:
libname tq84_lib 'p:\ath\to\dir';
proc sql;
select
memname,
memtype,
index,
engine
/* path */
from
dictionary.members
where
libname = 'TQ84_LIB';
quit;