topic Re: All data sets and columns in library sashelp in SAS Programming

All data sets and columns in library sashelp

Ronein — Sat, 17 May 2025 06:48:49 GMT

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

Re: All data sets and columns in library sashelp

Kurt_Bremser — Sat, 17 May 2025 07:50:06 GMT

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

Re: All data sets and columns in library sashelp

Ronein — Sat, 17 May 2025 15:29:12 GMT

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

Re: All data sets and columns in library sashelp

ballardw — Sat, 17 May 2025 15:43:32 GMT

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.

Re: All data sets and columns in library sashelp

Kurt_Bremser — Sat, 17 May 2025 18:21:58 GMT

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