topic Re: directory listing in SAS Data Management

directory listing

Thylacine — Wed, 12 Jul 2017 13:03:34 GMT

System is on unix i need a directory listing and tried:

filename dirlist pipe 'dir "pathTOdirectory" ';

data nazwy;
length fname $256;
infile dirlist truncover length= reclen;
input fname $varying256. reclen;
run;

but i keep getting all filenames in one row and not in seperate, what i'm i doing wrong?

Re: directory listing

RW9 — Wed, 12 Jul 2017 13:16:51 GMT

I always put a dlm= in the infile which can never happen in the returned information - you could probably look for CR/LF or other things:

filename dirlist pipe 'dir "pathTOdirectory" ';

data nazwy;
  length fname $256;
  infile dirlist truncover length=reclen dlm="¬";
  input fname $varying256. reclen;
run;

Thus, as the delimter is never hit, then it only goes to a new line on cr/lf.

Re: directory listing

Kurt_Bremser — Wed, 12 Jul 2017 13:29:21 GMT

On UNIX systems, use the native ls instead of the DOS dir mockup:

filename dirlist pipe 'ls path ';

data nazwy;
length fname $256;
infile dirlist truncover length= reclen;
input fname $varying256. reclen;
run;