How to specify pathname of filename with *

[japelin]

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 · Accepted solution]

Do this:

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

[japelin]

Thank you!

Your code works well!

I didn't know filename option.