all_tab_columns oracle equivalent in SAS eg

srinidelite — Wed, 29 Mar 2017 07:39:25 GMT

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 ?

Re: all_tab_columns oracle equivalent in SAS eg

gamotte — Wed, 29 Mar 2017 08:06:39 GMT

I think you are looking for dictionary.columns

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