Finding Column name in Schema using SAS EG

[amity21]

Hi, I am relatively new to SAS programming.

I am trying to locate tables with a column name (or like if possible) from a library in SAS EG.

I use to have a code for this in SAS base where it hits dictionary.columns but that does not work for SAS EG.

Can anyone please assist? 

Following is the SAS base code I use to use

proc sql ;
  select name 
  from dictionary.columns
  where memname = 'mydata'
  ;
quit ;

 Thank you.

[Kurt_Bremser · Accepted solution]

Use

select memname from dictionary.columns
where upcase(name) = 'MYCOL' and upcase(libname) = 'MYLIB'

to find all datasets in mylib that have a column mycol.

[jklaverstijn]

In EG it is often easier to use the views on the dictionary tables as they can be found in the SASHELP library. In your case the view would be SASHELP.VCOLUMN.

You can drop this table on the canvas and use a filter&sort or query builder on it.

I hope this helps,

- Jan.