macro variables in location

[brophymj]

I have a filename defined in my dataset:

filename cm  'k:\may 2015\cm.txt';

and in another program the month and year are defined as:

%let month = may;

%let year = 2015;

when I used the code

filename cm  'k:\&month. &year.\cm.txt';

it doesn't work

[Steelers_In_DC]

What does the log say?

[Reeza]

Macro variables need double quotes to resolve, they won't resolve in single quotes

[brophymj]

Log says...

Physical file does not exist,

'k:\&month. &year.\cm.txt'

it doesn't work with double quotations either.

[Reeza]

Use the following line to see what the macro variables are resolving to, also, make sure that the file actually exists

Options symbolgen mprint;

If that doesn't work, post your full code and log.

[TomKari · Accepted solution]

1. As previously mentioned, use double quotes not single.

2. Is your SAS session possibly running on a server that can't see your K: drive?

3. Could the macro variables be local when they're created, not global? In the program that's failing, put in the line

%put &month &year;

to see if the variables have values.