Help using Base SAS procedures

question on fileref

Reply
Occasional Contributor
Posts: 15

question on fileref

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

PROC Star
Posts: 7,356

question on fileref

How about enclosing it with double rather than single quotes?

Super User
Super User
Posts: 6,498

Re: question on fileref

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"));
Ask a Question
Discussion stats
  • 2 replies
  • 111 views
  • 3 likes
  • 3 in conversation