topic How to specify pathname of filename with * in SAS Programming

How to specify pathname of filename with *

japelin — Wed, 25 Dec 2019 05:46:45 GMT

Hello,

I want full path of filename using " * ".

But follow code gets only "c:\temp\*.csv".

filename test "c:\temp\*.csv";

data want;
  infile test dsd;
  length path $256;
  input a b;
  path=pathname('path');
run;

What I want is the value of the following path variable.

c:\temp\a.csv

c:\temp\b.csv

c:\temp\c.csv

I can get path value by using filename with pipe, dir command and loop proc import, but if i use filename with " * " is easy.

Thanks all help.

Kurt_Bremser — Wed, 25 Dec 2019 08:25:37 GMT

Do this:

data want;
length path fname $256;
infile "c:\temp\*.csv" dsd filename=fname;
path = fname;
input a b;
run;

japelin — Wed, 25 Dec 2019 08:42:14 GMT

Thank you!

Your code works well!

I didn't know filename option.