03-29-2017 03:39 AM
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 ?
03-29-2017 04:06 AM
I think you are looking for dictionary.columns
SELECT LIBNAME, MEMNAME, NAME FROM dictionary.columns
WHERE upcase(NAME) like "%WEI%";