topic Re: Getting names of all .csv files in directory in SAS University Edition in New SAS User

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

caeduspl — Thu, 01 Aug 2019 19:18:24 GMT

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-including-sub/td-p/430369, 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

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

Reeza — Thu, 01 Aug 2019 19:20:01 GMT

Have you tried this one?

https://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n0js70lrkxo6uvn1fl4a5aafnlgt.htm&docsetVersion=9.4&locale=en

@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-including-sub/td-p/430369, 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

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

Kurt_Bremser — Thu, 01 Aug 2019 19:31:54 GMT

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.

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

caeduspl — Thu, 01 Aug 2019 19:35:07 GMT

Thank you. It is simple too and works.

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

caeduspl — Thu, 01 Aug 2019 19:35:57 GMT

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