All data sets and columns in library sashelp

[Ronein]

Let's say that I want to check all data sets exist in specific library ( for example:sashelp library) and for each data set check the columns names. I want to create a data set that have multiple columns, each column get values of the columns names of each data set.
So-
The data set get following columns names-
Sashelp.Cars
Sashelp.class
And so on

[Kurt_Bremser]

It‘s already there: SASHELP.VCOLUMN (or DICTIONARY.COLUMNS in PROC SQL).

[Ronein]

But In real world I want to apply it on a permanent library that is not sashelp

[ballardw · Accepted solution]

Proc sql;
  create table work.want as
  select * 
  from dictionary.columns
  where libname='SASHELP' and memtype='DATA'
  ;
quit;

Replace the SASHELP with the name of the library in upper case as that is the way the value is stored in the view. The DATA is to restrict to only data sets and also needs to be upper case as stored that way.

[Kurt_Bremser]

Doesn‘t matter. DICTIONARY.COLUMNS has the metadata of all currently assigned libraries.