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

Accepted Solution Solved
Reply
Respected Advisor
Posts: 4,173
Accepted Solution

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

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


Accepted Solutions
Solution
‎01-01-2015 10:11 PM
Respected Advisor
Posts: 4,927

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

Is this better?

proc datasets library=sashelp nolist;

contents data=class;

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

run;

PG

PG

View solution in original post


All Replies
Solution
‎01-01-2015 10:11 PM
Respected Advisor
Posts: 4,927

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

Is this better?

proc datasets library=sashelp nolist;

contents data=class;

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

run;

PG

PG
Respected Advisor
Posts: 4,173

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

Much better, thanks!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 376 views
  • 0 likes
  • 2 in conversation