Getting names of all .csv files in directory in SAS University Edition

[caeduspl]

Dear Community,

I am trying to import a lot of .csv files in somewhat automated way. Idea of mine is to get names of all file in a single table then import each file using macrovariables within DATASTEP.

But I have a trobule with getting files' names. I tried solution mentioned in thread: https://communities.sas.com/t5/SAS-Data-Management/how-to-get-list-of-files-available-in-Directory-i..., namely:

filename tmp pipe 'dir "folders/myfolders/*.csv" /b /s';

data want;
  infile tmp dlm="¬";
  length cmd_line $2000;
  input cmd_line;
run;

But I get following error:

ERROR: Insufficient authorization to access PIPE.

Is it possible to use something like this using SAS University Edition? If it matters, I am using SAS Studio.
Best regards,
Maks

[Reeza · Accepted solution]

Have you tried this one?

https://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n0js70lrkxo6uvn1fl4a5aafnlgt.htm&docse...

---

@caeduspl wrote:

Dear Community,

I am trying to import a lot of .csv files in somewhat automated way. Idea of mine is to get names of all file in a single table then import each file using macrovariables within DATASTEP.

But I have a trobule with getting files' names. I tried solution mentioned in thread: https://communities.sas.com/t5/SAS-Data-Management/how-to-get-list-of-files-available-in-Directory-i..., namely:

filename tmp pipe 'dir "folders/myfolders/*.csv" /b /s';

data want;
  infile tmp dlm="¬";
  length cmd_line $2000;
  input cmd_line;
run;

But I get following error:

ERROR: Insufficient authorization to access PIPE.

Is it possible to use something like this using SAS University Edition? If it matters, I am using SAS Studio.
Best regards,
Maks

---

[caeduspl]

Thank you. It is simple too and works.

[Kurt_Bremser]

External commands (and that includes filename pipe) are not available in UE, so you need to use the dopen and dread functions.

BTW, UE runs on UNIX, so the command would be ls, not dir.

[caeduspl]

Thank you for pointing that out. I was not aware how it exactly works.