How to find physical path of SAS file in concatenated library?

[Patrick]

Hi all

For concatenated libraries with the same named table in multiple locations is there a simple way to show where the table has been picked up from.

Example:

SASHELP.CLASS exists under one of the paths. How can I determine under which path exactly. Is there some option or function which would allow me to retrieve this information?

(As an extension: If a file exists under multiple paths in a concatenated library then I would like to know from where it has been picked up - only talking V9 engine here and not SPDE).

I know that I could write a program which searches through all the paths in sequence for file class.sas7bdat - but is there a more direct way?

My environment is:  SAS 9.4 M2, Win X64_7PRO

Thanks

Patrick

[PGStats · Accepted solution]

Is this better?

proc datasets library=sashelp nolist;

contents data=class;

ods output enginehost=pathname(where=(label1="Filename"));

run;

PG

[Patrick]

Much better, thanks!