topic Find the fastest table and column names in bibliographies in SAS Programming

Find the fastest table and column names in bibliographies

Gieorgie — Mon, 04 Oct 2021 06:42:02 GMT

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

Re: Find the fastest table and column names in bibliographies

andreas_lds — Mon, 04 Oct 2021 07:04:47 GMT

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.

Re: Find the fastest table and column names in bibliographies

ballardw — Mon, 04 Oct 2021 15:24:23 GMT

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.