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 ?
I think you are looking for dictionary.columns
proc sql; SELECT LIBNAME, MEMNAME, NAME FROM dictionary.columns WHERE upcase(NAME) like "%WEI%";quit;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Save the date!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!