12-15-2016 11:48 PM
It is simple if you already have a connection to DB. libname xx odbc dsn=..............; proc sql; select * from dictionary.columns where libname='XX' and name='col_name'; quit;
12-15-2016 11:43 PM
Most DBs have a dictionary table that contains table and column names.
If your datasets sets are SAS data sets, check SASHELP.vcolumn to find all columns named Team.
If your dataset are from a DB they may not be listed in SASHELP but the DB should have its own dictionary.