topic Re: Questions about getting file names by FILENAME statement in SAS Programming

Questions about getting file names by FILENAME statement

ACQ32d — Wed, 27 Sep 2017 19:13:22 GMT

Hello everyone,

I am trying to get the filenames in a folder using filename statement but what if there is a single quote in my folder name?

For example, the following code:

filename names pipe 'dir "C:\user'name\folder\" /b';

It will cause an error because there is a ' (single quote) in the pathway (user'name). I don't want to change the pathway. Could anyone teach me how to make it work?

Thanks!

Re: Questions about getting file names by FILENAME statement

Kurt_Bremser — Wed, 27 Sep 2017 19:19:20 GMT

Get rid of that stupid quote three days before yesterday. Such characters have no place in path names, as they only cause unnecessary work.

Re: Questions about getting file names by FILENAME statement

PGStats — Wed, 27 Sep 2017 21:57:21 GMT

Double the single quote:

filename names pipe 'dir "C:\user''name\folder\" /b';

that's two single quotes between user and name.

Re: Questions about getting file names by FILENAME statement

Ksharp — Thu, 28 Sep 2017 14:58:07 GMT



filename names pipe dir %sysfunc(quote("C:\user'name\folder\" /b));

Re: Questions about getting file names by FILENAME statement

Ksharp — Thu, 28 Sep 2017 15:05:02 GMT


filename names pipe  %sysfunc(quote(dir "C:\user'name\folder\" /b));