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

Patrick — Fri, 02 Jan 2015 02:23:06 GMT

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

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

PGStats — Fri, 02 Jan 2015 03:11:21 GMT

Is this better?

proc datasets library=sashelp nolist;

contents data=class;

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

run;

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

Patrick — Fri, 02 Jan 2015 04:28:53 GMT

Much better, thanks!

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

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

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

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