Hi Rob, It's not entirely clear from your email whether you're looking for a particular field without knowing which table it's on, or for a specific data value without knowing which filed and table it's on. The former is much easier than the latter to solve - when you run SAS (or EGuide, etc) it should automatically create libraries in your list, like the WORK library. One of these is SASHELP, and it contains a lot of useful information about the other data in your SAS session - metadata of a sort. For example, SASHELP.VLIBNAM is a list of the libraries you have assigned (and can be used to find their physical locations, whether they're read-only, on your machine or a server etc etc). SASHELP.VTABLE is basically the next level down, being a list of the various tables which exist. SASHELP.VCOLUMN might be your friend here, it's a list of columns by library and the table they appear on, which might be a good way to find your mysterious data. If you are looking for a value rather than a column name, you could use SASHELP.VCOLUMN to narrow down the search, either in a SAS macro or by hand, by finding only the numeric or date columns as appropriate. For character ones, you can also eliminate any which don't have enough length to accomodate what you're looking for. The actual process of searching each column for the value in question might be very slow and tedious though, depending on the size of your library and datasets.
... View more