Macroname in file name

rhapsody — Mon, 11 Mar 2019 13:41:28 GMT

I wanna open the Excel file "January_Alex..xlsx". I'm using the following code

%let name=Alex;

x '"C:\Folder\January_&name..xlsx" ';

But the problem is that SAS doesn't understand that "&name" is a macrovariable. I get the error message "Windows cannot find 'C:\Folder\January_&name..xlsx'. Make sure you typed the name correctly, and then try again"

Any ideas how to fix it?

Re: Macroname in file name

Tom — Mon, 11 Mar 2019 13:47:36 GMT

@rhapsody wrote:

I wanna open the Excel file "January_Alex..xlsx". I'm using the following code
%let name=Alex;

x '"C:\Folder\January_&name..xlsx" ';
But the problem is that SAS doesn't understand that "&name" is a macrovariable. I get the error message "Windows cannot find 'C:\Folder\January_&name..xlsx'. Make sure you typed the name correctly, and then try again"

Any ideas how to fix it?

SAS will not resolve macro references inside of single quotes. Use double quotes. If you want to include double quotes in the string passed to DOS/Windows then double the embedded quotes;

"""C:\Folder\January_&name..xlsx"""

Or let the QUOTE() function do it for you.

%let cmd="C:\Folder\January_&name..xlsx";
x %sysfunc(quote(&cmd));

topic Macroname in file name in SAS Programming

Macroname in file name

Re: Macroname in file name