Proc SQL;
create table want as
select libname, memname, name
from dictionary.columns
where libname='WORK' and memtype='DATA'
;
quit;
or
data otherwant;
set sashelp.vcolumn;
where libname='WORK' and memtype='DATA';
run;
SAS keeps all that metadata in special data views in the SASHELP library. You can look at them with any tool you like. The Proc SQL treats them as members of a special set of members in the DICTIONARY (note that is not really a library as more than 8 characters) that has different members that contain information about data variables (columns), data sets, libraries, external files, macros, title statements and more.
... View more