how to get numeric variables and character variables for all dataset in a library

[Anandkvn]

data ds1;
set sashelp.class;
run;


data ds2;
set sashelp.cars;
run;


proc sql;
select MEMNAME into: numvar separated by " "
from dictionary.tables
where LIBNAME="WORK"
      and
MEMNAME="DATA"
      and
TYPE="num";  /*'CHAR"*/
quit;

How to get all numeric and character variables from all datasets in a library

[SASKiwi · Accepted solution]

proc sql;
  create table columns as
  select *
  from dictionary.columns
  where libname = 'WORK';
quit;

[yabwon]

proc contents data=WORK._ALL_ out=Variables noprint;
run;

[Anandkvn]

Thank you  very munch yabwon for your solution