topic Re: Find the path of a filename in SAS Programming

Find the path of a filename

chithra — Wed, 20 Sep 2017 06:15:20 GMT

Dear All,

I need to find the pathname of a filename in sas. The input should be only the filename.

Is it possible in SAS? or anybody knows how this can be done in UNIX?

Thanks,

Chithra

Re: Find the path of a filename

ShiroAmada — Wed, 20 Sep 2017 07:02:54 GMT

Try this.....

data WANT;
filename="c:\windows\text.txt";
path=substr(filename,1,find(filename,reverse(scan(reverse(filename),1,"\")))-1);
run;

Hope this helps.

Re: Find the path of a filename

chithra — Wed, 20 Sep 2017 07:13:47 GMT

Thanks.

But i have only the file name text.txt with me.

Don't know the path.

Re: Find the path of a filename

ShiroAmada — Wed, 20 Sep 2017 07:13:52 GMT

Here's a step by step approach

data test;
  value='C:\Windows\Test.txt';
  file=scan(value,-1,"\");
  endpos=find(value,strip(file));
path=substr(value,1,endpos-1);
run;

Re: Find the path of a filename

SASKiwi — Wed, 20 Sep 2017 07:27:47 GMT

To find a file on a Unix server, type this at a Unix command line: find / -name text.txt

I wouldn't recommend doing this from SAS, assuming that you only want to do it once

Re: Find the path of a filename

ShiroAmada — Wed, 20 Sep 2017 07:36:07 GMT

Oh now i understand.

Now try this.


options noxwait;
FILENAME pathloc 'e:\test.txt';

data MYPATH;
  x "dir e:\sample.txt /s /p > e:\test.txt";
infile pathloc;
input locator $100.;
if indexw(locator,'Directory of');
run;

#1 assign a fileref (just like a libname statement)

#2 Use x command and specify a directory and the file that will be searched, file is saved (same as fileref).

#3. Read the saved file.

#4 Look and retian the keywords "Directory of"

Hope this helps.

Re: Find the path of a filename

chithra — Wed, 20 Sep 2017 08:23:21 GMT

yes..exactly.

Thanks. I use this command with pipe and it works fine.

Re: Find the path of a filename

chithra — Wed, 20 Sep 2017 08:26:16 GMT

Thanks.

I tried this also. This helps.

Re: Find the path of a filename

PatrickCuba — Wed, 29 Aug 2018 11:40:41 GMT

Go here

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245924.htm

Re: Find the path of a filename

JimE — Mon, 23 Mar 2020 12:13:30 GMT

To find the path to a filename use:

%let myFilePath=%sysfunc(pathname(myFileName));

or for a library, use:

%let myLibraryPath=%sysfunc(pathname(myLibName));

See: https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245924.htm