I would like to create a new table with all tables contained within a library and the variables within each of those tables. I know I can use something like the below to get the table name but I cant find much on getting each variable. I have multiple libraries and each has potentially hundreds of tables. Any help really appreciated.

proc sql ;
  create table mytables as
  select *
  from dictionary.tables
  where libname IN ('WORK','SPDSWORK',etc)
  order by memname ;
quit ;

>Solution :

Use distionary.columns instead.

proc sql ;
  create table mytables as
  select *
  from dictionary.columns
  where libname IN ('SASHELP')
  order by memname ;
quit ;