topic Re: How do I get the name of the file a Libref is referring to? in SAS Programming

How do I get the name of the file a Libref is referring to?

pplummer62 — Wed, 19 Jul 2017 14:59:00 GMT

I am wondering if there is a way to pull the name of the file defined in the LIBNAME statement into a variable.

That is, is there an analog to the FILENAME= option of the INFILE statement for the SET statement?

I would like to be able to access the name of the file to place it in report titles.

Thanks.

Re: How do I get the name of the file a Libref is referring to?

Astounding — Wed, 19 Jul 2017 15:29:05 GMT

The SET statement supports the INDSNAME= option. That should be a possibility.

http://support.sas.com/documentation/cdl/en/lestmtsref/69738/HTML/default/viewer.htm#p00hxg3x8lwivcn1f0e9axziw57y.htm

Re: How do I get the name of the file a Libref is referring to?

kiranv_ — Wed, 19 Jul 2017 15:37:35 GMT

you can extract pathnames from dictionary.members or by using pathname function. Need to use capital letters while using dictionary.members. replace yourlib with libname

proc sql ;
select distinct path as path_var from dictionary.members
where libname= 'YOURLIB';
data abc;
path_var=pathname('yourlib');
run;

Re: How do I get the name of the file a Libref is referring to?

pplummer62 — Wed, 19 Jul 2017 15:52:39 GMT

This almost does it.
If you have the statement LIBNAME FILEREF "SASDATASET; in your program

Then when you use this: SET FILEREF.SETNAME INDSNAME= DSNAME , the value of DSNAME is FILEREF.SETNAME when what I was wanting it to be equal to SASDATASET.

Re: How do I get the name of the file a Libref is referring to?

kiranv_ — Wed, 19 Jul 2017 17:00:59 GMT

looks like you have by mistakenly, selected my answer as accepted answer instead of @Astounding answer

Re: How do I get the name of the file a Libref is referring to?

Astounding — Wed, 19 Jul 2017 17:03:52 GMT

You could easily have been right ... I wasn't sure what the end goal was either.

At any rate, use the SCAN function to pick out the second part of the name returned by INDSNAME=:

member_name = scan(full_name, 2, '.');

Re: How do I get the name of the file a Libref is referring to?

pplummer62 — Fri, 21 Jul 2017 12:15:02 GMT

I found that this worked when using a file on the SAS server.

What I failed to mention was that I was using the code while connected to the mainframe. When connected to the mainframe, it is necessary to use the PROC SQL answer of kirnav_.

Re: How do I get the name of the file a Libref is referring to?

Tom — Fri, 21 Jul 2017 12:46:36 GMT

The PATHNAME() function will return the path that a libref or fileref is using.

You can use it in a data step.

data _null_;
  length path $256 ;
  path=pathname('mylib');
  put path= ;
run;

Or wrap it in %SYSFUNC() and use it directly in macro code.

%let path=%sysfunc(pathname(mylib));

You can also ask PROC CONTENTS to tell you where a particular dataset is. That is useful if you libref is actually pointing to multiple directories.

proc contents data=mylib.mymember;
run;