Find the fastest table and column names in bibliographies

[Gieorgie]

I have a lot of libraries and our administrators changed the names of the libraries when they were moved to another server. Tell me if there is any chance that some find function will find table names, column names, e.g.REVAL_RATEMID
from _kplus.K_FXRATES  if _kplus no longer exists

[andreas_lds · Accepted solution]

Ask the admins to provide a list containing old and new names of the libraries. If they don't have such a list, well, then someone should explain them the impact of their doings, especially how much time (=money) it will cost to fix all broken programs. In the meantime query sashelp.vcolum. The view has a list of all variables in each dataset.

[ballardw]

If all they did was change the names of libraries but did not move them you can look at SASHELP.VSLIB which has the name of the library and the current path(s) defining that library. Perhaps you know what the old path was then this would be pretty helpful.

SASHELP.VTABLE will just the names of data sets and libraries if you don't need to find variable information. If you had multiple data sets with the same names in different libraries that may not be a much help as you need but may give you a start.