DATA Step, Macro, Functions and more

all_tab_columns oracle equivalent in SAS eg

Reply
Contributor
Posts: 20

all_tab_columns oracle equivalent in SAS eg

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 ?

 

 

Regular Contributor
Posts: 233

Re: all_tab_columns oracle equivalent in SAS eg

Posted in reply to srinidelite

I think you are looking for dictionary.columns

 

proc sql;
    SELECT LIBNAME, MEMNAME, NAME FROM dictionary.columns
    WHERE upcase(NAME) like "%WEI%";
quit;
Ask a Question
Discussion stats
  • 1 reply
  • 142 views
  • 0 likes
  • 2 in conversation