topic Re: Finding Column name in Schema using SAS EG in SAS Enterprise Guide

Finding Column name in Schema using SAS EG

amity21 — Fri, 17 Feb 2017 14:46:14 GMT

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.

Re: Finding Column name in Schema using SAS EG

Kurt_Bremser — Fri, 17 Feb 2017 14:52:09 GMT

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.

Re: Finding Column name in Schema using SAS EG

jklaverstijn — Fri, 17 Feb 2017 14:54:42 GMT

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.