question on fileref

[telescopic]

Question for the external reference to directory, the following does not work because of the space at "Desktop 2012". How should i correct it when there is a space in the directory name?

filename Saledata 'C:\Users\Jeff\Desktop 2012\sale.txt';

Thank you

Elvin

[art297]

How about enclosing it with double rather than single quotes?

[Tom]

Normally that syntax should work.  It is when you try to use the paths with spaces or other special characters in a operating system command that you need the quotes.  Embed double quotes inside the outerquotes.

filename xx '"c:\My Documents\xx.txt"';

You can also use dquotes on the outside (for SAS) so that SAS will resolve macro references.  In this cause the internal quotes need to be doubled up so that SAS knows they are not the end of the quote.

filename xx """c:\My Documents\xx.txt""";

You can make it easier to type by using the quote() function.

filename xx %sysfunc(quote("c:\My Documents\xx.txt"));