all_tab_columns oracle equivalent in SAS eg

[srinidelite]

I'm trying find a column from no of libararies i have created for my project... since im from oracle background i use the below query

select * from all_tab_columns where column_name like '%ColName%' 

However in SAS eg i really dont know how to do the above .. can someone please help me out ?

[gamotte]

I think you are looking for dictionary.columns

proc sql;
    SELECT LIBNAME, MEMNAME, NAME FROM dictionary.columns
    WHERE upcase(NAME) like "%WEI%";
quit;