02-10-2012 02:17 PM
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';
02-10-2012 02:28 PM
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"));