topic Re: Filename pipe with blanks in the directory name in New SAS User

Filename pipe with blanks in the directory name

Illodolaio — Wed, 13 Feb 2019 13:55:41 GMT

Hi everybody,

I got this code

filename fnames pipe "dir /ds/data star/* /b";

data fnames;
infile fnames pad missover;
input @1 filename $255.;
run;

It reads all the files in the directory and create a dataset with one record for each file in the directory.

The problem is the blank in the middle of the name of the directory, data star.
If I remove this blank (and put datastar instead of data star, for example) is OK.
With it, it reads a not correct path, /ds/data.
I can't remove the blank in the directory name so could I do to obtain the correct path?

Thanks

Re: Filename pipe with blanks in the directory name

RW9 — Wed, 13 Feb 2019 14:47:36 GMT

Its a matter of quoting:

filename fnames pipe 'dir "/ds/data star" /b';

Put single quotes around the string, and use double quotes around the network path.

Re: Filename pipe with blanks in the directory name

Illodolaio — Thu, 14 Feb 2019 08:44:00 GMT

Thanks !